﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="PCV_CLINICDataSetTongHop" targetNamespace="http://tempuri.org/PCV_CLINICDataSetTongHop.xsd" xmlns:mstns="http://tempuri.org/PCV_CLINICDataSetTongHop.xsd" xmlns="http://tempuri.org/PCV_CLINICDataSetTongHop.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" GeneratorFunctionsComponentClassName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" UserFunctionsComponentName="QueriesTableAdapter" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="PCV_CLINICConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="PCV_CLINICConnectionString (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.PCV_Clinic_Pro.My.MySettings.GlobalReference.Default.PCV_CLINICConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="getTonKho_CanhBao_HanDungTableAdapter" GeneratorDataComponentClassName="getTonKho_CanhBao_HanDungTableAdapter" Name="getTonKho_CanhBao_HanDung" UserDataComponentName="getTonKho_CanhBao_HanDungTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PCV_CLINICConnectionString (MySettings)" DbObjectName="PCV_CLINIC.dbo.getTonKho_CanhBao_HanDung" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.getTonKho_CanhBao_HanDung</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@ngay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="mahang" DataSetColumn="mahang" />
              <Mapping SourceColumn="tenhang" DataSetColumn="tenhang" />
              <Mapping SourceColumn="dvt" DataSetColumn="dvt" />
              <Mapping SourceColumn="quicach" DataSetColumn="quicach" />
              <Mapping SourceColumn="solo" DataSetColumn="solo" />
              <Mapping SourceColumn="hsd" DataSetColumn="hsd" />
              <Mapping SourceColumn="soluongdauky" DataSetColumn="soluongdauky" />
              <Mapping SourceColumn="thanhtiendauky" DataSetColumn="thanhtiendauky" />
              <Mapping SourceColumn="soluongnhap" DataSetColumn="soluongnhap" />
              <Mapping SourceColumn="thanhtiennhap" DataSetColumn="thanhtiennhap" />
              <Mapping SourceColumn="soluongxuat" DataSetColumn="soluongxuat" />
              <Mapping SourceColumn="thanhtienxuat" DataSetColumn="thanhtienxuat" />
              <Mapping SourceColumn="soluongcuoiky" DataSetColumn="soluongcuoiky" />
              <Mapping SourceColumn="thanhtiencuoiky" DataSetColumn="thanhtiencuoiky" />
              <Mapping SourceColumn="canhbaohandung" DataSetColumn="canhbaohandung" />
              <Mapping SourceColumn="songayconlai" DataSetColumn="songayconlai" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="getTonKho_CanhBao_SoLuongToiDaTableAdapter" GeneratorDataComponentClassName="getTonKho_CanhBao_SoLuongToiDaTableAdapter" Name="getTonKho_CanhBao_SoLuongToiDa" UserDataComponentName="getTonKho_CanhBao_SoLuongToiDaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PCV_CLINICConnectionString (MySettings)" DbObjectName="PCV_CLINIC.dbo.getTonKho_CanhBao_SoLuongToiDa" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.getTonKho_CanhBao_SoLuongToiDa</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@tungay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@denngay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="mahang" DataSetColumn="mahang" />
              <Mapping SourceColumn="tenhang" DataSetColumn="tenhang" />
              <Mapping SourceColumn="dvt" DataSetColumn="dvt" />
              <Mapping SourceColumn="quicach" DataSetColumn="quicach" />
              <Mapping SourceColumn="solo" DataSetColumn="solo" />
              <Mapping SourceColumn="hsd" DataSetColumn="hsd" />
              <Mapping SourceColumn="soluongdauky" DataSetColumn="soluongdauky" />
              <Mapping SourceColumn="thanhtiendauky" DataSetColumn="thanhtiendauky" />
              <Mapping SourceColumn="soluongnhap" DataSetColumn="soluongnhap" />
              <Mapping SourceColumn="thanhtiennhap" DataSetColumn="thanhtiennhap" />
              <Mapping SourceColumn="soluongxuat" DataSetColumn="soluongxuat" />
              <Mapping SourceColumn="thanhtienxuat" DataSetColumn="thanhtienxuat" />
              <Mapping SourceColumn="soluongcuoiky" DataSetColumn="soluongcuoiky" />
              <Mapping SourceColumn="thanhtiencuoiky" DataSetColumn="thanhtiencuoiky" />
              <Mapping SourceColumn="tonkhotoida" DataSetColumn="tonkhotoida" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="getTonKho_CanhBao_SoLuongToiThieuTableAdapter" GeneratorDataComponentClassName="getTonKho_CanhBao_SoLuongToiThieuTableAdapter" Name="getTonKho_CanhBao_SoLuongToiThieu" UserDataComponentName="getTonKho_CanhBao_SoLuongToiThieuTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PCV_CLINICConnectionString (MySettings)" DbObjectName="PCV_CLINIC.dbo.getTonKho_CanhBao_SoLuongToiThieu" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.getTonKho_CanhBao_SoLuongToiThieu</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@tungay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@denngay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="mahang" DataSetColumn="mahang" />
              <Mapping SourceColumn="tenhang" DataSetColumn="tenhang" />
              <Mapping SourceColumn="dvt" DataSetColumn="dvt" />
              <Mapping SourceColumn="quicach" DataSetColumn="quicach" />
              <Mapping SourceColumn="solo" DataSetColumn="solo" />
              <Mapping SourceColumn="hsd" DataSetColumn="hsd" />
              <Mapping SourceColumn="soluongdauky" DataSetColumn="soluongdauky" />
              <Mapping SourceColumn="thanhtiendauky" DataSetColumn="thanhtiendauky" />
              <Mapping SourceColumn="soluongnhap" DataSetColumn="soluongnhap" />
              <Mapping SourceColumn="thanhtiennhap" DataSetColumn="thanhtiennhap" />
              <Mapping SourceColumn="soluongxuat" DataSetColumn="soluongxuat" />
              <Mapping SourceColumn="thanhtienxuat" DataSetColumn="thanhtienxuat" />
              <Mapping SourceColumn="soluongcuoiky" DataSetColumn="soluongcuoiky" />
              <Mapping SourceColumn="thanhtiencuoiky" DataSetColumn="thanhtiencuoiky" />
              <Mapping SourceColumn="tonkhotoithieu" DataSetColumn="tonkhotoithieu" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TCTonKhoTableAdapter" GeneratorDataComponentClassName="TCTonKhoTableAdapter" Name="TCTonKho" UserDataComponentName="TCTonKhoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PCV_CLINICConnectionString (MySettings)" DbObjectName="PCV_Clinic.dbo.TCTonKho" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[TCTonKho] WHERE (([ma] = @Original_ma) AND ((@IsNull_sochungtu = 1 AND [sochungtu] IS NULL) OR ([sochungtu] = @Original_sochungtu)) AND ((@IsNull_ngaychungtu = 1 AND [ngaychungtu] IS NULL) OR ([ngaychungtu] = @Original_ngaychungtu)) AND ((@IsNull_sohoadon = 1 AND [sohoadon] IS NULL) OR ([sohoadon] = @Original_sohoadon)) AND ((@IsNull_ngayhoadon = 1 AND [ngayhoadon] IS NULL) OR ([ngayhoadon] = @Original_ngayhoadon)) AND ((@IsNull_mahang = 1 AND [mahang] IS NULL) OR ([mahang] = @Original_mahang)) AND ((@IsNull_tenhang = 1 AND [tenhang] IS NULL) OR ([tenhang] = @Original_tenhang)) AND ((@IsNull_quicach = 1 AND [quicach] IS NULL) OR ([quicach] = @Original_quicach)) AND ((@IsNull_dvt = 1 AND [dvt] IS NULL) OR ([dvt] = @Original_dvt)) AND ((@IsNull_solo = 1 AND [solo] IS NULL) OR ([solo] = @Original_solo)) AND ((@IsNull_sologoc = 1 AND [sologoc] IS NULL) OR ([sologoc] = @Original_sologoc)) AND ((@IsNull_hsd = 1 AND [hsd] IS NULL) OR ([hsd] = @Original_hsd)) AND ((@IsNull_soluongdauky = 1 AND [soluongdauky] IS NULL) OR ([soluongdauky] = @Original_soluongdauky)) AND ((@IsNull_thanhtiendauky = 1 AND [thanhtiendauky] IS NULL) OR ([thanhtiendauky] = @Original_thanhtiendauky)) AND ((@IsNull_soluongnhap = 1 AND [soluongnhap] IS NULL) OR ([soluongnhap] = @Original_soluongnhap)) AND ((@IsNull_thanhtiennhap = 1 AND [thanhtiennhap] IS NULL) OR ([thanhtiennhap] = @Original_thanhtiennhap)) AND ((@IsNull_soluongxuat = 1 AND [soluongxuat] IS NULL) OR ([soluongxuat] = @Original_soluongxuat)) AND ((@IsNull_thanhtienxuat = 1 AND [thanhtienxuat] IS NULL) OR ([thanhtienxuat] = @Original_thanhtienxuat)) AND ((@IsNull_soluongcuoiky = 1 AND [soluongcuoiky] IS NULL) OR ([soluongcuoiky] = @Original_soluongcuoiky)) AND ((@IsNull_thanhtiencuoiky = 1 AND [thanhtiencuoiky] IS NULL) OR ([thanhtiencuoiky] = @Original_thanhtiencuoiky)) AND ((@IsNull_mafifo = 1 AND [mafifo] IS NULL) OR ([mafifo] = @Original_mafifo)) AND ((@IsNull_kyketoan = 1 AND [kyketoan] IS NULL) OR ([kyketoan] = @Original_kyketoan)) AND ((@IsNull_chinhanh = 1 AND [chinhanh] IS NULL) OR ([chinhanh] = @Original_chinhanh)) AND ((@IsNull_uid = 1 AND [uid] IS NULL) OR ([uid] = @Original_uid)) AND ([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sochungtu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sochungtu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_sochungtu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sochungtu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngaychungtu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngaychungtu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngaychungtu" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaychungtu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sohoadon" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sohoadon" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_sohoadon" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sohoadon" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngayhoadon" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngayhoadon" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngayhoadon" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngayhoadon" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_mahang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mahang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_mahang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mahang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tenhang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tenhang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tenhang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tenhang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_quicach" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="quicach" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_quicach" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="quicach" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dvt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dvt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_dvt" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dvt" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_solo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="solo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_solo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="solo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sologoc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sologoc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_sologoc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sologoc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hsd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hsd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_hsd" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="hsd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_soluongdauky" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="soluongdauky" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_soluongdauky" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="soluongdauky" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_thanhtiendauky" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="thanhtiendauky" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_thanhtiendauky" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thanhtiendauky" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_soluongnhap" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="soluongnhap" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_soluongnhap" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="soluongnhap" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_thanhtiennhap" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="thanhtiennhap" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_thanhtiennhap" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thanhtiennhap" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_soluongxuat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="soluongxuat" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_soluongxuat" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="soluongxuat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_thanhtienxuat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="thanhtienxuat" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_thanhtienxuat" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thanhtienxuat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_soluongcuoiky" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="soluongcuoiky" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_soluongcuoiky" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="soluongcuoiky" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_thanhtiencuoiky" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="thanhtiencuoiky" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_thanhtiencuoiky" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thanhtiencuoiky" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_mafifo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mafifo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_mafifo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mafifo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_kyketoan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="kyketoan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_kyketoan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="kyketoan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chinhanh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_uid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="uid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_uid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="uid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[TCTonKho] ([ma], [sochungtu], [ngaychungtu], [sohoadon], [ngayhoadon], [mahang], [tenhang], [quicach], [dvt], [solo], [sologoc], [hsd], [soluongdauky], [thanhtiendauky], [soluongnhap], [thanhtiennhap], [soluongxuat], [thanhtienxuat], [soluongcuoiky], [thanhtiencuoiky], [mafifo], [kyketoan], [chinhanh], [uid]) VALUES (@ma, @sochungtu, @ngaychungtu, @sohoadon, @ngayhoadon, @mahang, @tenhang, @quicach, @dvt, @solo, @sologoc, @hsd, @soluongdauky, @thanhtiendauky, @soluongnhap, @thanhtiennhap, @soluongxuat, @thanhtienxuat, @soluongcuoiky, @thanhtiencuoiky, @mafifo, @kyketoan, @chinhanh, @uid);
SELECT ma, sochungtu, ngaychungtu, sohoadon, ngayhoadon, mahang, tenhang, quicach, dvt, solo, sologoc, hsd, soluongdauky, thanhtiendauky, soluongnhap, thanhtiennhap, soluongxuat, thanhtienxuat, soluongcuoiky, thanhtiencuoiky, mafifo, kyketoan, chinhanh, uid, id FROM TCTonKho WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sochungtu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sochungtu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngaychungtu" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaychungtu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sohoadon" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sohoadon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngayhoadon" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngayhoadon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@mahang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mahang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tenhang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tenhang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@quicach" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="quicach" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@dvt" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dvt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@solo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="solo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sologoc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sologoc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@hsd" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="hsd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@soluongdauky" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="soluongdauky" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@thanhtiendauky" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thanhtiendauky" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@soluongnhap" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="soluongnhap" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@thanhtiennhap" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thanhtiennhap" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@soluongxuat" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="soluongxuat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@thanhtienxuat" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thanhtienxuat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@soluongcuoiky" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="soluongcuoiky" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@thanhtiencuoiky" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thanhtiencuoiky" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@mafifo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mafifo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@kyketoan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="kyketoan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@uid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="uid" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ma, sochungtu, ngaychungtu, sohoadon, ngayhoadon, mahang, tenhang, quicach, dvt, solo, sologoc, hsd, soluongdauky, thanhtiendauky, soluongnhap, thanhtiennhap, soluongxuat, thanhtienxuat, soluongcuoiky, thanhtiencuoiky, mafifo, kyketoan, chinhanh, uid, id FROM dbo.TCTonKho</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[TCTonKho] SET [ma] = @ma, [sochungtu] = @sochungtu, [ngaychungtu] = @ngaychungtu, [sohoadon] = @sohoadon, [ngayhoadon] = @ngayhoadon, [mahang] = @mahang, [tenhang] = @tenhang, [quicach] = @quicach, [dvt] = @dvt, [solo] = @solo, [sologoc] = @sologoc, [hsd] = @hsd, [soluongdauky] = @soluongdauky, [thanhtiendauky] = @thanhtiendauky, [soluongnhap] = @soluongnhap, [thanhtiennhap] = @thanhtiennhap, [soluongxuat] = @soluongxuat, [thanhtienxuat] = @thanhtienxuat, [soluongcuoiky] = @soluongcuoiky, [thanhtiencuoiky] = @thanhtiencuoiky, [mafifo] = @mafifo, [kyketoan] = @kyketoan, [chinhanh] = @chinhanh, [uid] = @uid WHERE (([ma] = @Original_ma) AND ((@IsNull_sochungtu = 1 AND [sochungtu] IS NULL) OR ([sochungtu] = @Original_sochungtu)) AND ((@IsNull_ngaychungtu = 1 AND [ngaychungtu] IS NULL) OR ([ngaychungtu] = @Original_ngaychungtu)) AND ((@IsNull_sohoadon = 1 AND [sohoadon] IS NULL) OR ([sohoadon] = @Original_sohoadon)) AND ((@IsNull_ngayhoadon = 1 AND [ngayhoadon] IS NULL) OR ([ngayhoadon] = @Original_ngayhoadon)) AND ((@IsNull_mahang = 1 AND [mahang] IS NULL) OR ([mahang] = @Original_mahang)) AND ((@IsNull_tenhang = 1 AND [tenhang] IS NULL) OR ([tenhang] = @Original_tenhang)) AND ((@IsNull_quicach = 1 AND [quicach] IS NULL) OR ([quicach] = @Original_quicach)) AND ((@IsNull_dvt = 1 AND [dvt] IS NULL) OR ([dvt] = @Original_dvt)) AND ((@IsNull_solo = 1 AND [solo] IS NULL) OR ([solo] = @Original_solo)) AND ((@IsNull_sologoc = 1 AND [sologoc] IS NULL) OR ([sologoc] = @Original_sologoc)) AND ((@IsNull_hsd = 1 AND [hsd] IS NULL) OR ([hsd] = @Original_hsd)) AND ((@IsNull_soluongdauky = 1 AND [soluongdauky] IS NULL) OR ([soluongdauky] = @Original_soluongdauky)) AND ((@IsNull_thanhtiendauky = 1 AND [thanhtiendauky] IS NULL) OR ([thanhtiendauky] = @Original_thanhtiendauky)) AND ((@IsNull_soluongnhap = 1 AND [soluongnhap] IS NULL) OR ([soluongnhap] = @Original_soluongnhap)) AND ((@IsNull_thanhtiennhap = 1 AND [thanhtiennhap] IS NULL) OR ([thanhtiennhap] = @Original_thanhtiennhap)) AND ((@IsNull_soluongxuat = 1 AND [soluongxuat] IS NULL) OR ([soluongxuat] = @Original_soluongxuat)) AND ((@IsNull_thanhtienxuat = 1 AND [thanhtienxuat] IS NULL) OR ([thanhtienxuat] = @Original_thanhtienxuat)) AND ((@IsNull_soluongcuoiky = 1 AND [soluongcuoiky] IS NULL) OR ([soluongcuoiky] = @Original_soluongcuoiky)) AND ((@IsNull_thanhtiencuoiky = 1 AND [thanhtiencuoiky] IS NULL) OR ([thanhtiencuoiky] = @Original_thanhtiencuoiky)) AND ((@IsNull_mafifo = 1 AND [mafifo] IS NULL) OR ([mafifo] = @Original_mafifo)) AND ((@IsNull_kyketoan = 1 AND [kyketoan] IS NULL) OR ([kyketoan] = @Original_kyketoan)) AND ((@IsNull_chinhanh = 1 AND [chinhanh] IS NULL) OR ([chinhanh] = @Original_chinhanh)) AND ((@IsNull_uid = 1 AND [uid] IS NULL) OR ([uid] = @Original_uid)) AND ([id] = @Original_id));
SELECT ma, sochungtu, ngaychungtu, sohoadon, ngayhoadon, mahang, tenhang, quicach, dvt, solo, sologoc, hsd, soluongdauky, thanhtiendauky, soluongnhap, thanhtiennhap, soluongxuat, thanhtienxuat, soluongcuoiky, thanhtiencuoiky, mafifo, kyketoan, chinhanh, uid, id FROM TCTonKho WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sochungtu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sochungtu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngaychungtu" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaychungtu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sohoadon" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sohoadon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngayhoadon" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngayhoadon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@mahang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mahang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tenhang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tenhang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@quicach" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="quicach" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@dvt" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dvt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@solo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="solo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sologoc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sologoc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@hsd" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="hsd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@soluongdauky" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="soluongdauky" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@thanhtiendauky" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thanhtiendauky" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@soluongnhap" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="soluongnhap" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@thanhtiennhap" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thanhtiennhap" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@soluongxuat" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="soluongxuat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@thanhtienxuat" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thanhtienxuat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@soluongcuoiky" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="soluongcuoiky" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@thanhtiencuoiky" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thanhtiencuoiky" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@mafifo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mafifo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@kyketoan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="kyketoan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@uid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="uid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sochungtu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sochungtu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_sochungtu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sochungtu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngaychungtu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngaychungtu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngaychungtu" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaychungtu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sohoadon" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sohoadon" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_sohoadon" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sohoadon" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngayhoadon" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngayhoadon" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngayhoadon" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngayhoadon" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_mahang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mahang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_mahang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mahang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tenhang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tenhang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tenhang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tenhang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_quicach" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="quicach" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_quicach" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="quicach" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dvt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dvt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_dvt" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dvt" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_solo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="solo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_solo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="solo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sologoc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sologoc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_sologoc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sologoc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hsd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hsd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_hsd" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="hsd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_soluongdauky" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="soluongdauky" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_soluongdauky" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="soluongdauky" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_thanhtiendauky" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="thanhtiendauky" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_thanhtiendauky" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thanhtiendauky" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_soluongnhap" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="soluongnhap" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_soluongnhap" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="soluongnhap" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_thanhtiennhap" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="thanhtiennhap" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_thanhtiennhap" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thanhtiennhap" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_soluongxuat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="soluongxuat" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_soluongxuat" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="soluongxuat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_thanhtienxuat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="thanhtienxuat" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_thanhtienxuat" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thanhtienxuat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_soluongcuoiky" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="soluongcuoiky" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_soluongcuoiky" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="soluongcuoiky" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_thanhtiencuoiky" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="thanhtiencuoiky" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_thanhtiencuoiky" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thanhtiencuoiky" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_mafifo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mafifo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_mafifo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mafifo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_kyketoan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="kyketoan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_kyketoan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="kyketoan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chinhanh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_uid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="uid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_uid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="uid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="PCV_CLINIC.dbo.TCTonKho" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@id" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ma" DataSetColumn="ma" />
              <Mapping SourceColumn="sochungtu" DataSetColumn="sochungtu" />
              <Mapping SourceColumn="ngaychungtu" DataSetColumn="ngaychungtu" />
              <Mapping SourceColumn="sohoadon" DataSetColumn="sohoadon" />
              <Mapping SourceColumn="ngayhoadon" DataSetColumn="ngayhoadon" />
              <Mapping SourceColumn="mahang" DataSetColumn="mahang" />
              <Mapping SourceColumn="tenhang" DataSetColumn="tenhang" />
              <Mapping SourceColumn="quicach" DataSetColumn="quicach" />
              <Mapping SourceColumn="dvt" DataSetColumn="dvt" />
              <Mapping SourceColumn="solo" DataSetColumn="solo" />
              <Mapping SourceColumn="sologoc" DataSetColumn="sologoc" />
              <Mapping SourceColumn="hsd" DataSetColumn="hsd" />
              <Mapping SourceColumn="soluongdauky" DataSetColumn="soluongdauky" />
              <Mapping SourceColumn="thanhtiendauky" DataSetColumn="thanhtiendauky" />
              <Mapping SourceColumn="soluongnhap" DataSetColumn="soluongnhap" />
              <Mapping SourceColumn="thanhtiennhap" DataSetColumn="thanhtiennhap" />
              <Mapping SourceColumn="soluongxuat" DataSetColumn="soluongxuat" />
              <Mapping SourceColumn="thanhtienxuat" DataSetColumn="thanhtienxuat" />
              <Mapping SourceColumn="soluongcuoiky" DataSetColumn="soluongcuoiky" />
              <Mapping SourceColumn="thanhtiencuoiky" DataSetColumn="thanhtiencuoiky" />
              <Mapping SourceColumn="mafifo" DataSetColumn="mafifo" />
              <Mapping SourceColumn="kyketoan" DataSetColumn="kyketoan" />
              <Mapping SourceColumn="chinhanh" DataSetColumn="chinhanh" />
              <Mapping SourceColumn="uid" DataSetColumn="uid" />
              <Mapping SourceColumn="id" DataSetColumn="id" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="PCV_CLINICConnectionString (MySettings)" DbObjectName="PCV_CLINIC.dbo.getTCTonKho_isTonTai_DauKy" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="getTCTonKho_isTonTai_DauKy" Modifier="Public" Name="getTCTonKho_isTonTai_DauKy" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="getTCTonKho_isTonTai_DauKy">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.getTCTonKho_isTonTai_DauKy</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@kyketoan" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PCV_CLINICConnectionString (MySettings)" DbObjectName="PCV_CLINIC.dbo.setCapNhatDauKy_DenThangHienTai" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="setCapNhatDauKy_DenThangHienTai" Modifier="Public" Name="setCapNhatDauKy_DenThangHienTai" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="setCapNhatDauKy_DenThangHienTai">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.setCapNhatDauKy_DenThangHienTai</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@ngay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@mahang" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@solo" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@handung" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PCV_CLINICConnectionString (MySettings)" DbObjectName="PCV_CLINIC.dbo.setTCTonKho_LayDauKy" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="setTCTonKho_LayDauKy" Modifier="Public" Name="setTCTonKho_LayDauKy" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="setTCTonKho_LayDauKy">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.setTCTonKho_LayDauKy</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@tungay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="getTCTonKho_isTonTai_DauKyTableAdapter" GeneratorDataComponentClassName="getTCTonKho_isTonTai_DauKyTableAdapter" Name="getTCTonKho_isTonTai_DauKy" UserDataComponentName="getTCTonKho_isTonTai_DauKyTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PCV_CLINICConnectionString (MySettings)" DbObjectName="PCV_CLINIC.dbo.getTCTonKho_isTonTai_DauKy" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.getTCTonKho_isTonTai_DauKy</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@kyketoan" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Column1" DataSetColumn="Column1" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="getBHBanHangChiTiet_PhieuXuatCuoiTableAdapter" GeneratorDataComponentClassName="getBHBanHangChiTiet_PhieuXuatCuoiTableAdapter" Name="getBHBanHangChiTiet_PhieuXuatCuoi" UserDataComponentName="getBHBanHangChiTiet_PhieuXuatCuoiTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PCV_CLINICConnectionString (MySettings)" DbObjectName="PCV_CLINIC.dbo.getBHBanHangChiTiet_PhieuXuatCuoi" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.getBHBanHangChiTiet_PhieuXuatCuoi</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@mahang" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@solo" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@handung" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ma" DataSetColumn="ma" />
              <Mapping SourceColumn="ngaychungtu" DataSetColumn="ngaychungtu" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="getTCTonKho_TonKhoTheoLo_HanDungTableAdapter" GeneratorDataComponentClassName="getTCTonKho_TonKhoTheoLo_HanDungTableAdapter" Name="getTCTonKho_TonKhoTheoLo_HanDung" UserDataComponentName="getTCTonKho_TonKhoTheoLo_HanDungTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PCV_CLINICConnectionString (MySettings)" DbObjectName="PCV_CLINIC.dbo.getTCTonKho_TonKhoTheoLo_HanDung" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.getTCTonKho_TonKhoTheoLo_HanDung</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@tungay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@denngay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="mahang" DataSetColumn="mahang" />
              <Mapping SourceColumn="tenhang" DataSetColumn="tenhang" />
              <Mapping SourceColumn="dvt" DataSetColumn="dvt" />
              <Mapping SourceColumn="quicach" DataSetColumn="quicach" />
              <Mapping SourceColumn="solo" DataSetColumn="solo" />
              <Mapping SourceColumn="hsd" DataSetColumn="hsd" />
              <Mapping SourceColumn="soluongdauky" DataSetColumn="soluongdauky" />
              <Mapping SourceColumn="thanhtiendauky" DataSetColumn="thanhtiendauky" />
              <Mapping SourceColumn="soluongnhap" DataSetColumn="soluongnhap" />
              <Mapping SourceColumn="thanhtiennhap" DataSetColumn="thanhtiennhap" />
              <Mapping SourceColumn="soluongxuat" DataSetColumn="soluongxuat" />
              <Mapping SourceColumn="thanhtienxuat" DataSetColumn="thanhtienxuat" />
              <Mapping SourceColumn="soluongcuoiky" DataSetColumn="soluongcuoiky" />
              <Mapping SourceColumn="thanhtiencuoiky" DataSetColumn="thanhtiencuoiky" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="getTCTonKho_TonKhoTongHopTableAdapter" GeneratorDataComponentClassName="getTCTonKho_TonKhoTongHopTableAdapter" Name="getTCTonKho_TonKhoTongHop" UserDataComponentName="getTCTonKho_TonKhoTongHopTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PCV_CLINICConnectionString (MySettings)" DbObjectName="PCV_CLINIC.dbo.getTCTonKho_TonKhoTongHop" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.getTCTonKho_TonKhoTongHop</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@kyketoan" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="mahang" DataSetColumn="mahang" />
              <Mapping SourceColumn="tenhang" DataSetColumn="tenhang" />
              <Mapping SourceColumn="dvt" DataSetColumn="dvt" />
              <Mapping SourceColumn="quicach" DataSetColumn="quicach" />
              <Mapping SourceColumn="soluongcuoiky" DataSetColumn="soluongcuoiky" />
              <Mapping SourceColumn="thanhtiencuoiky" DataSetColumn="thanhtiencuoiky" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="get_SoLuongCuoiKy_TonKho_Lo_HanDung_KhaDungTableAdapter" GeneratorDataComponentClassName="get_SoLuongCuoiKy_TonKho_Lo_HanDung_KhaDungTableAdapter" Name="get_SoLuongCuoiKy_TonKho_Lo_HanDung_KhaDung" UserDataComponentName="get_SoLuongCuoiKy_TonKho_Lo_HanDung_KhaDungTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PCV_CLINICConnectionString (MySettings)" DbObjectName="PCV_CLINIC.dbo.get_SoLuongCuoiKy_TonKho_Lo_HanDung_KhaDung" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.get_SoLuongCuoiKy_TonKho_Lo_HanDung_KhaDung</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@tungay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@denngay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@solo" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@handung" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="soluongcuoiky" DataSetColumn="soluongcuoiky" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="getSoNhatKyMuaHangTableAdapter" GeneratorDataComponentClassName="getSoNhatKyMuaHangTableAdapter" Name="getSoNhatKyMuaHang" UserDataComponentName="getSoNhatKyMuaHangTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PCV_CLINICConnectionString (MySettings)" DbObjectName="PCV_CLINIC.dbo.getSoNhatKyMuaHang" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.getSoNhatKyMuaHang</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@tungay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@denngay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ma" DataSetColumn="ma" />
              <Mapping SourceColumn="manghiepvu" DataSetColumn="manghiepvu" />
              <Mapping SourceColumn="sochungtu" DataSetColumn="sochungtu" />
              <Mapping SourceColumn="ngaychungtu" DataSetColumn="ngaychungtu" />
              <Mapping SourceColumn="taikhoanno" DataSetColumn="taikhoanno" />
              <Mapping SourceColumn="taikhoanco" DataSetColumn="taikhoanco" />
              <Mapping SourceColumn="thanhtienvnd" DataSetColumn="thanhtienvnd" />
              <Mapping SourceColumn="tilethueGTGT" DataSetColumn="tilethueGTGT" />
              <Mapping SourceColumn="tienthueGTGT" DataSetColumn="tienthueGTGT" />
              <Mapping SourceColumn="taikhoanthueGTGT" DataSetColumn="taikhoanthueGTGT" />
              <Mapping SourceColumn="chinhanh" DataSetColumn="chinhanh" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="getSoNhatKyBanHangTableAdapter" GeneratorDataComponentClassName="getSoNhatKyBanHangTableAdapter" Name="getSoNhatKyBanHang" UserDataComponentName="getSoNhatKyBanHangTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PCV_CLINICConnectionString (MySettings)" DbObjectName="PCV_CLINIC.dbo.getSoNhatKyBanHang" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.getSoNhatKyBanHang</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@tungay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@denngay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ma" DataSetColumn="ma" />
              <Mapping SourceColumn="manghiepvu" DataSetColumn="manghiepvu" />
              <Mapping SourceColumn="sochungtu" DataSetColumn="sochungtu" />
              <Mapping SourceColumn="ngaychungtu" DataSetColumn="ngaychungtu" />
              <Mapping SourceColumn="taikhoanno" DataSetColumn="taikhoanno" />
              <Mapping SourceColumn="taikhoanco" DataSetColumn="taikhoanco" />
              <Mapping SourceColumn="thanhtienvnd" DataSetColumn="thanhtienvnd" />
              <Mapping SourceColumn="tilethueGTGT" DataSetColumn="tilethueGTGT" />
              <Mapping SourceColumn="tienthueGTGT" DataSetColumn="tienthueGTGT" />
              <Mapping SourceColumn="taikhoanthueGTGT" DataSetColumn="taikhoanthueGTGT" />
              <Mapping SourceColumn="chinhanh" DataSetColumn="chinhanh" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="getGia_BangGiaApDungTableAdapter" GeneratorDataComponentClassName="getGia_BangGiaApDungTableAdapter" Name="getGia_BangGiaApDung" UserDataComponentName="getGia_BangGiaApDungTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PCV_CLINICConnectionString (MySettings)" DbObjectName="PCV_CLINIC.dbo.getGia_BangGiaApDung" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.getGia_BangGiaApDung</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@ngay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@doituong" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="mahang" DataSetColumn="mahang" />
              <Mapping SourceColumn="giaban" DataSetColumn="giaban" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="PCV_CLINICConnectionString (MySettings)" DbObjectName="PCV_CLINIC.dbo.getTonTaiBangGia" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="getTonTaiBangGia" Modifier="Public" Name="getTonTaiBangGia" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="getTonTaiBangGia">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.getTonTaiBangGia</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@ngay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@doituong" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CanDoiTaiKhoanTableAdapter" GeneratorDataComponentClassName="CanDoiTaiKhoanTableAdapter" Name="CanDoiTaiKhoan" UserDataComponentName="CanDoiTaiKhoanTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PCV_CLINICConnectionString (MySettings)" DbObjectName="PCV_Clinic.dbo.CanDoiTaiKhoan" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT nodauky, codauky, psno, psco, nocuoiky, cocuoiky, taikhoan, kyketoan, chinhanh, cap, tentaikhoan FROM CanDoiTaiKhoan</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="nodauky" DataSetColumn="nodauky" />
              <Mapping SourceColumn="codauky" DataSetColumn="codauky" />
              <Mapping SourceColumn="psno" DataSetColumn="psno" />
              <Mapping SourceColumn="psco" DataSetColumn="psco" />
              <Mapping SourceColumn="nocuoiky" DataSetColumn="nocuoiky" />
              <Mapping SourceColumn="cocuoiky" DataSetColumn="cocuoiky" />
              <Mapping SourceColumn="taikhoan" DataSetColumn="taikhoan" />
              <Mapping SourceColumn="kyketoan" DataSetColumn="kyketoan" />
              <Mapping SourceColumn="chinhanh" DataSetColumn="chinhanh" />
              <Mapping SourceColumn="tentaikhoan" DataSetColumn="tentaikhoan" />
              <Mapping SourceColumn="cap" DataSetColumn="cap" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TonQuyTableAdapter" GeneratorDataComponentClassName="TonQuyTableAdapter" Name="TonQuy" UserDataComponentName="TonQuyTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PCV_CLINICConnectionString (MySettings)" DbObjectName="PCV_Clinic.dbo.TonQuy" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT sochungtu, ngaychungtu, taikhoan, phatsinhco, phatsinhno, chinhanh, cap, kyketoan FROM TonQuy</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="sochungtu" DataSetColumn="sochungtu" />
              <Mapping SourceColumn="ngaychungtu" DataSetColumn="ngaychungtu" />
              <Mapping SourceColumn="taikhoan" DataSetColumn="taikhoan" />
              <Mapping SourceColumn="phatsinhco" DataSetColumn="phatsinhco" />
              <Mapping SourceColumn="phatsinhno" DataSetColumn="phatsinhno" />
              <Mapping SourceColumn="chinhanh" DataSetColumn="chinhanh" />
              <Mapping SourceColumn="cap" DataSetColumn="cap" />
              <Mapping SourceColumn="kyketoan" DataSetColumn="kyketoan" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="getTCCongNo_PhaiThuTableAdapter" GeneratorDataComponentClassName="getTCCongNo_PhaiThuTableAdapter" Name="getTCCongNo_PhaiThu" UserDataComponentName="getTCCongNo_PhaiThuTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PCV_CLINICConnectionString (MySettings)" DbObjectName="PCV_CLINIC.dbo.getTCCongNo_PhaiThu" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.getTCCongNo_PhaiThu</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@tungay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@denngay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ma" DataSetColumn="ma" />
              <Mapping SourceColumn="ten" DataSetColumn="ten" />
              <Mapping SourceColumn="diachi" DataSetColumn="diachi" />
              <Mapping SourceColumn="nodauky" DataSetColumn="nodauky" />
              <Mapping SourceColumn="phatsinhno" DataSetColumn="phatsinhno" />
              <Mapping SourceColumn="phatsinhco" DataSetColumn="phatsinhco" />
              <Mapping SourceColumn="nocuoiky" DataSetColumn="nocuoiky" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="getTCCongNo_PhaiTraTableAdapter" GeneratorDataComponentClassName="getTCCongNo_PhaiTraTableAdapter" Name="getTCCongNo_PhaiTra" UserDataComponentName="getTCCongNo_PhaiTraTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PCV_CLINICConnectionString (MySettings)" DbObjectName="PCV_CLINIC.dbo.getTCCongNo_PhaiTra" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.getTCCongNo_PhaiTra</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@tungay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@denngay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ma" DataSetColumn="ma" />
              <Mapping SourceColumn="ten" DataSetColumn="ten" />
              <Mapping SourceColumn="diachi" DataSetColumn="diachi" />
              <Mapping SourceColumn="nodauky" DataSetColumn="nodauky" />
              <Mapping SourceColumn="phatsinhno" DataSetColumn="phatsinhno" />
              <Mapping SourceColumn="phatsinhco" DataSetColumn="phatsinhco" />
              <Mapping SourceColumn="nocuoiky" DataSetColumn="nocuoiky" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="getHoSoBenhNhanTableAdapter" GeneratorDataComponentClassName="getHoSoBenhNhanTableAdapter" Name="getHoSoBenhNhan" UserDataComponentName="getHoSoBenhNhanTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PCV_CLINICConnectionString (MySettings)" DbObjectName="PCV_Clinic.dbo.getHoSoBenhNhan" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.getHoSoBenhNhan</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@tungay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@denngay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@loabenhnhan" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ma" DataSetColumn="ma" />
              <Mapping SourceColumn="sotiepnhan" DataSetColumn="sotiepnhan" />
              <Mapping SourceColumn="ngaytiepnhan" DataSetColumn="ngaytiepnhan" />
              <Mapping SourceColumn="loaibenhnhan" DataSetColumn="loaibenhnhan" />
              <Mapping SourceColumn="mabenhnhan" DataSetColumn="mabenhnhan" />
              <Mapping SourceColumn="ten" DataSetColumn="ten" />
              <Mapping SourceColumn="tuoi" DataSetColumn="tuoi" />
              <Mapping SourceColumn="namsinh" DataSetColumn="namsinh" />
              <Mapping SourceColumn="gioitinh" DataSetColumn="gioitinh" />
              <Mapping SourceColumn="dantoc" DataSetColumn="dantoc" />
              <Mapping SourceColumn="diachi" DataSetColumn="diachi" />
              <Mapping SourceColumn="sobhyt" DataSetColumn="sobhyt" />
              <Mapping SourceColumn="traituyen" DataSetColumn="traituyen" />
              <Mapping SourceColumn="ngaybatdau" DataSetColumn="ngaybatdau" />
              <Mapping SourceColumn="ngayhethan" DataSetColumn="ngayhethan" />
              <Mapping SourceColumn="ngaythangnamsinh" DataSetColumn="ngaythangnamsinh" />
              <Mapping SourceColumn="noicongtac" DataSetColumn="noicongtac" />
              <Mapping SourceColumn="nghenghiep" DataSetColumn="nghenghiep" />
              <Mapping SourceColumn="quocgia" DataSetColumn="quocgia" />
              <Mapping SourceColumn="tinhthanh" DataSetColumn="tinhthanh" />
              <Mapping SourceColumn="quanhuyen" DataSetColumn="quanhuyen" />
              <Mapping SourceColumn="phuongxa" DataSetColumn="phuongxa" />
              <Mapping SourceColumn="thonphoduong" DataSetColumn="thonphoduong" />
              <Mapping SourceColumn="sonha" DataSetColumn="sonha" />
              <Mapping SourceColumn="uutien" DataSetColumn="uutien" />
              <Mapping SourceColumn="dienthoai" DataSetColumn="dienthoai" />
              <Mapping SourceColumn="email" DataSetColumn="email" />
              <Mapping SourceColumn="noigioithieu" DataSetColumn="noigioithieu" />
              <Mapping SourceColumn="chandoansobo" DataSetColumn="chandoansobo" />
              <Mapping SourceColumn="lydokham" DataSetColumn="lydokham" />
              <Mapping SourceColumn="chonkham" DataSetColumn="chonkham" />
              <Mapping SourceColumn="bacsi" DataSetColumn="bacsi" />
              <Mapping SourceColumn="phong" DataSetColumn="phong" />
              <Mapping SourceColumn="ngaykhamgannhat" DataSetColumn="ngaykhamgannhat" />
              <Mapping SourceColumn="solanden" DataSetColumn="solanden" />
              <Mapping SourceColumn="solannamvien" DataSetColumn="solannamvien" />
              <Mapping SourceColumn="ghichu" DataSetColumn="ghichu" />
              <Mapping SourceColumn="tinhtrang" DataSetColumn="tinhtrang" />
              <Mapping SourceColumn="chinhanh" DataSetColumn="chinhanh" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="getHoSoChuyenVienTableAdapter" GeneratorDataComponentClassName="getHoSoChuyenVienTableAdapter" Name="getHoSoChuyenVien" UserDataComponentName="getHoSoChuyenVienTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PCV_CLINICConnectionString (MySettings)" DbObjectName="PCV_Clinic.dbo.getHoSoChuyenVien" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.getHoSoChuyenVien</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@tungay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@denngay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ma" DataSetColumn="ma" />
              <Mapping SourceColumn="sophieu" DataSetColumn="sophieu" />
              <Mapping SourceColumn="mabenhnhan" DataSetColumn="mabenhnhan" />
              <Mapping SourceColumn="tenbenhnhan" DataSetColumn="tenbenhnhan" />
              <Mapping SourceColumn="benhvien" DataSetColumn="benhvien" />
              <Mapping SourceColumn="tenbenhvien" DataSetColumn="tenbenhvien" />
              <Mapping SourceColumn="diachibenhvien" DataSetColumn="diachibenhvien" />
              <Mapping SourceColumn="dauhieulamsang" DataSetColumn="dauhieulamsang" />
              <Mapping SourceColumn="cacxetnghiem" DataSetColumn="cacxetnghiem" />
              <Mapping SourceColumn="chandoan" DataSetColumn="chandoan" />
              <Mapping SourceColumn="thuocdadung" DataSetColumn="thuocdadung" />
              <Mapping SourceColumn="tinhtrangnguoibenh" DataSetColumn="tinhtrangnguoibenh" />
              <Mapping SourceColumn="lydochuyenvien" DataSetColumn="lydochuyenvien" />
              <Mapping SourceColumn="phuongtienvanchuyen" DataSetColumn="phuongtienvanchuyen" />
              <Mapping SourceColumn="nguoiduadi" DataSetColumn="nguoiduadi" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="getHoSoSinhHieuTableAdapter" GeneratorDataComponentClassName="getHoSoSinhHieuTableAdapter" Name="getHoSoSinhHieu" UserDataComponentName="getHoSoSinhHieuTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PCV_CLINICConnectionString (MySettings)" DbObjectName="PCV_Clinic.dbo.getHoSoSinhHieu" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.getHoSoSinhHieu</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@tungay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@denngay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ma" DataSetColumn="ma" />
              <Mapping SourceColumn="masophieu" DataSetColumn="masophieu" />
              <Mapping SourceColumn="mabenhnhan" DataSetColumn="mabenhnhan" />
              <Mapping SourceColumn="ten" DataSetColumn="ten" />
              <Mapping SourceColumn="gioitinh" DataSetColumn="gioitinh" />
              <Mapping SourceColumn="ngaysinh" DataSetColumn="ngaysinh" />
              <Mapping SourceColumn="tuoi" DataSetColumn="tuoi" />
              <Mapping SourceColumn="sobhyt" DataSetColumn="sobhyt" />
              <Mapping SourceColumn="hanbhyt" DataSetColumn="hanbhyt" />
              <Mapping SourceColumn="diachi" DataSetColumn="diachi" />
              <Mapping SourceColumn="ngaydo" DataSetColumn="ngaydo" />
              <Mapping SourceColumn="mach" DataSetColumn="mach" />
              <Mapping SourceColumn="nhietdo" DataSetColumn="nhietdo" />
              <Mapping SourceColumn="huyetap" DataSetColumn="huyetap" />
              <Mapping SourceColumn="nhiptho" DataSetColumn="nhiptho" />
              <Mapping SourceColumn="cannang" DataSetColumn="cannang" />
              <Mapping SourceColumn="chieucao" DataSetColumn="chieucao" />
              <Mapping SourceColumn="vongbung" DataSetColumn="vongbung" />
              <Mapping SourceColumn="bmi" DataSetColumn="bmi" />
              <Mapping SourceColumn="ghichu" DataSetColumn="ghichu" />
              <Mapping SourceColumn="tinhtrang" DataSetColumn="tinhtrang" />
              <Mapping SourceColumn="chinhanh" DataSetColumn="chinhanh" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="getHoSoXetNghiemTableAdapter" GeneratorDataComponentClassName="getHoSoXetNghiemTableAdapter" Name="getHoSoXetNghiem" UserDataComponentName="getHoSoXetNghiemTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PCV_CLINICConnectionString (MySettings)" DbObjectName="PCV_Clinic.dbo.getHoSoXetNghiem" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.getHoSoXetNghiem</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@tungay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@denngay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@madichvu" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ma" DataSetColumn="ma" />
              <Mapping SourceColumn="sophieu" DataSetColumn="sophieu" />
              <Mapping SourceColumn="mabenhnhan" DataSetColumn="mabenhnhan" />
              <Mapping SourceColumn="tenbenhnhan" DataSetColumn="tenbenhnhan" />
              <Mapping SourceColumn="tuoi" DataSetColumn="tuoi" />
              <Mapping SourceColumn="gioitinh" DataSetColumn="gioitinh" />
              <Mapping SourceColumn="diachi" DataSetColumn="diachi" />
              <Mapping SourceColumn="sobhyt" DataSetColumn="sobhyt" />
              <Mapping SourceColumn="hanbhyt" DataSetColumn="hanbhyt" />
              <Mapping SourceColumn="chinhanh" DataSetColumn="chinhanh" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="getTCTonQuyTableAdapter" GeneratorDataComponentClassName="getTCTonQuyTableAdapter" Name="getTCTonQuy" UserDataComponentName="getTCTonQuyTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PCV_CLINICConnectionString (MySettings)" DbObjectName="PCV_Clinic.dbo.getTCTonQuy" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.getTCTonQuy</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@tungay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@denngay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="sochungtu" DataSetColumn="sochungtu" />
              <Mapping SourceColumn="ngaychungtu" DataSetColumn="ngaychungtu" />
              <Mapping SourceColumn="taikhoan" DataSetColumn="taikhoan" />
              <Mapping SourceColumn="chinhanh" DataSetColumn="chinhanh" />
              <Mapping SourceColumn="phatsinhno" DataSetColumn="phatsinhno" />
              <Mapping SourceColumn="phatsinhco" DataSetColumn="phatsinhco" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="getTCCanDoiTaiKhoanTableAdapter" GeneratorDataComponentClassName="getTCCanDoiTaiKhoanTableAdapter" Name="getTCCanDoiTaiKhoan" UserDataComponentName="getTCCanDoiTaiKhoanTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PCV_CLINICConnectionString (MySettings)" DbObjectName="PCV_Clinic.dbo.getTCCanDoiTaiKhoan" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.getTCCanDoiTaiKhoan</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@tungay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@denngay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="taikhoan" DataSetColumn="taikhoan" />
              <Mapping SourceColumn="tentaikhoan" DataSetColumn="tentaikhoan" />
              <Mapping SourceColumn="nodauky" DataSetColumn="nodauky" />
              <Mapping SourceColumn="codauky" DataSetColumn="codauky" />
              <Mapping SourceColumn="phatsinhno" DataSetColumn="phatsinhno" />
              <Mapping SourceColumn="phatsinhco" DataSetColumn="phatsinhco" />
              <Mapping SourceColumn="nocuoiky" DataSetColumn="nocuoiky" />
              <Mapping SourceColumn="cocuoiky" DataSetColumn="cocuoiky" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="getTCTonKho_TheKho_TheoLo_HanDungTableAdapter" GeneratorDataComponentClassName="getTCTonKho_TheKho_TheoLo_HanDungTableAdapter" Name="getTCTonKho_TheKho_TheoLo_HanDung" UserDataComponentName="getTCTonKho_TheKho_TheoLo_HanDungTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PCV_CLINICConnectionString (MySettings)" DbObjectName="PCV_Clinic.dbo.getTCTonKho_TheKho_TheoLo_HanDung" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.getTCTonKho_TheKho_TheoLo_HanDung</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@tungay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@denngay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@mahang" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@loai" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ma" DataSetColumn="ma" />
              <Mapping SourceColumn="ngaychungtu" DataSetColumn="ngaychungtu" />
              <Mapping SourceColumn="sochungtu" DataSetColumn="sochungtu" />
              <Mapping SourceColumn="sohoadon" DataSetColumn="sohoadon" />
              <Mapping SourceColumn="ngayhoadon" DataSetColumn="ngayhoadon" />
              <Mapping SourceColumn="mahang" DataSetColumn="mahang" />
              <Mapping SourceColumn="tenhang" DataSetColumn="tenhang" />
              <Mapping SourceColumn="dvt" DataSetColumn="dvt" />
              <Mapping SourceColumn="quicach" DataSetColumn="quicach" />
              <Mapping SourceColumn="solo" DataSetColumn="solo" />
              <Mapping SourceColumn="hsd" DataSetColumn="hsd" />
              <Mapping SourceColumn="soluongdauky" DataSetColumn="soluongdauky" />
              <Mapping SourceColumn="soluongnhap" DataSetColumn="soluongnhap" />
              <Mapping SourceColumn="soluongxuat" DataSetColumn="soluongxuat" />
              <Mapping SourceColumn="soluongcuoiky" DataSetColumn="soluongcuoiky" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="getTonKho_Lo_HanDung_KhaDungTableAdapter" GeneratorDataComponentClassName="getTonKho_Lo_HanDung_KhaDungTableAdapter" Name="getTonKho_Lo_HanDung_KhaDung" UserDataComponentName="getTonKho_Lo_HanDung_KhaDungTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PCV_CLINICConnectionString (MySettings)" DbObjectName="PCV_Clinic.dbo.getTonKho_Lo_HanDung_KhaDung" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.getTonKho_Lo_HanDung_KhaDung</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@tungay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@denngay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="mahang" DataSetColumn="mahang" />
              <Mapping SourceColumn="tenhang" DataSetColumn="tenhang" />
              <Mapping SourceColumn="dvt" DataSetColumn="dvt" />
              <Mapping SourceColumn="quicach" DataSetColumn="quicach" />
              <Mapping SourceColumn="solo" DataSetColumn="solo" />
              <Mapping SourceColumn="hsd" DataSetColumn="hsd" />
              <Mapping SourceColumn="soluongdauky" DataSetColumn="soluongdauky" />
              <Mapping SourceColumn="thanhtiendauky" DataSetColumn="thanhtiendauky" />
              <Mapping SourceColumn="soluongnhap" DataSetColumn="soluongnhap" />
              <Mapping SourceColumn="thanhtiennhap" DataSetColumn="thanhtiennhap" />
              <Mapping SourceColumn="soluongxuat" DataSetColumn="soluongxuat" />
              <Mapping SourceColumn="thanhtienxuat" DataSetColumn="thanhtienxuat" />
              <Mapping SourceColumn="soluongcuoiky" DataSetColumn="soluongcuoiky" />
              <Mapping SourceColumn="thanhtiencuoiky" DataSetColumn="thanhtiencuoiky" />
              <Mapping SourceColumn="chuoiduynhat" DataSetColumn="chuoiduynhat" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="PCV_CLINICConnectionString (MySettings)" DbObjectName="PCV_Clinic.dbo.get_SoLuongCuoiKy_TonKho_Lo_HanDung_KhaDung" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="get_SoLuongCuoiKy_TonKho_Lo_HanDung_KhaDung" Modifier="Public" Name="get_SoLuongCuoiKy_TonKho_Lo_HanDung_KhaDung" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="get_SoLuongCuoiKy_TonKho_Lo_HanDung_KhaDung">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.get_SoLuongCuoiKy_TonKho_Lo_HanDung_KhaDung</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@tungay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@denngay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@solo" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@handung" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="getTonKho_Lo_HanDung_ThucTableAdapter" GeneratorDataComponentClassName="getTonKho_Lo_HanDung_ThucTableAdapter" Name="getTonKho_Lo_HanDung_Thuc" UserDataComponentName="getTonKho_Lo_HanDung_ThucTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PCV_CLINICConnectionString (MySettings)" DbObjectName="PCV_Clinic.dbo.getTonKho_Lo_HanDung_Thuc" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.getTonKho_Lo_HanDung_Thuc</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@tungay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@denngay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@loai" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="mahang" DataSetColumn="mahang" />
              <Mapping SourceColumn="tenhang" DataSetColumn="tenhang" />
              <Mapping SourceColumn="dvt" DataSetColumn="dvt" />
              <Mapping SourceColumn="quicach" DataSetColumn="quicach" />
              <Mapping SourceColumn="solo" DataSetColumn="solo" />
              <Mapping SourceColumn="hsd" DataSetColumn="hsd" />
              <Mapping SourceColumn="soluongdauky" DataSetColumn="soluongdauky" />
              <Mapping SourceColumn="thanhtiendauky" DataSetColumn="thanhtiendauky" />
              <Mapping SourceColumn="soluongnhap" DataSetColumn="soluongnhap" />
              <Mapping SourceColumn="thanhtiennhap" DataSetColumn="thanhtiennhap" />
              <Mapping SourceColumn="soluongxuat" DataSetColumn="soluongxuat" />
              <Mapping SourceColumn="thanhtienxuat" DataSetColumn="thanhtienxuat" />
              <Mapping SourceColumn="soluongcuoiky" DataSetColumn="soluongcuoiky" />
              <Mapping SourceColumn="thanhtiencuoiky" DataSetColumn="thanhtiencuoiky" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources>
          <DbSource ConnectionRef="PCV_CLINICConnectionString (MySettings)" DbObjectName="PCV_CLINIC.dbo.getTonTaiBangGia" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="getTonTaiBangGia" MethodsParameterType="CLR" Modifier="Public" Name="getTonTaiBangGia" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="getTonTaiBangGia">
            <SelectCommand>
              <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                <CommandText>dbo.getTonTaiBangGia</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@ngay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@doituong" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
          <DbSource ConnectionRef="PCV_CLINICConnectionString (MySettings)" DbObjectName="PCV_Clinic.dbo.getSoChungTu_BHBanHang" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="getSoChungTu_BHBanHang" MethodsParameterType="CLR" Modifier="Public" Name="getSoChungTu_BHBanHang" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="getSoChungTu_BHBanHang">
            <SelectCommand>
              <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                <CommandText>dbo.getSoChungTu_BHBanHang</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@tiento" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@tungay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@denngay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
          <DbSource ConnectionRef="PCV_CLINICConnectionString (MySettings)" DbObjectName="PCV_Clinic.dbo.getSoChungTu_KHHangHoa" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="getSoChungTu_KHHangHoa" MethodsParameterType="CLR" Modifier="Public" Name="getSoChungTu_KHHangHoa" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="getSoChungTu_KHHangHoa">
            <SelectCommand>
              <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                <CommandText>dbo.getSoChungTu_KHHangHoa</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@tiento" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@tungay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@denngay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
          <DbSource ConnectionRef="PCV_CLINICConnectionString (MySettings)" DbObjectName="PCV_Clinic.dbo.getSoToaThuoc_ToaThuocMau" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="getSoToaThuoc_ToaThuocMau" MethodsParameterType="CLR" Modifier="Public" Name="getSoToaThuoc_ToaThuocMau" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="getSoToaThuoc_ToaThuocMau">
            <SelectCommand>
              <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                <CommandText>dbo.getSoToaThuoc_ToaThuocMau</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@tiento" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@ngay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
          <DbSource ConnectionRef="PCV_CLINICConnectionString (MySettings)" DbObjectName="PCV_Clinic.dbo.getMaBangGia_BHBangGia" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="getMaBangGia_BHBangGia" MethodsParameterType="CLR" Modifier="Public" Name="getMaBangGia_BHBangGia" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy4" UserSourceName="getMaBangGia_BHBangGia">
            <SelectCommand>
              <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                <CommandText>dbo.getMaBangGia_BHBangGia</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@tiento" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@tungay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@denngay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
          <DbSource ConnectionRef="PCV_CLINICConnectionString (MySettings)" DbObjectName="PCV_Clinic.dbo.getMaCTKM_BHChuongTrinhKhuyenMai" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="getMaCTKM_BHChuongTrinhKhuyenMai" MethodsParameterType="CLR" Modifier="Public" Name="getMaCTKM_BHChuongTrinhKhuyenMai" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy5" UserSourceName="getMaCTKM_BHChuongTrinhKhuyenMai">
            <SelectCommand>
              <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                <CommandText>dbo.getMaCTKM_BHChuongTrinhKhuyenMai</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@tiento" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@tungay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@denngay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
          <DbSource ConnectionRef="PCV_CLINICConnectionString (MySettings)" DbObjectName="PCV_Clinic.dbo.getSoChungTu_TCTien_NganHang" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="getSoChungTu_TCTien_NganHang" MethodsParameterType="CLR" Modifier="Public" Name="getSoChungTu_TCTien_NganHang" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy6" UserSourceName="getSoChungTu_TCTien_NganHang">
            <SelectCommand>
              <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                <CommandText>dbo.getSoChungTu_TCTien_NganHang</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@tiento" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@tungay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@denngay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
          <DbSource ConnectionRef="PCV_CLINICConnectionString (MySettings)" DbObjectName="PCV_Clinic.dbo.getSoChungTu_TCTien_TienMat" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="getSoChungTu_TCTien_TienMat" MethodsParameterType="CLR" Modifier="Public" Name="getSoChungTu_TCTien_TienMat" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy7" UserSourceName="getSoChungTu_TCTien_TienMat">
            <SelectCommand>
              <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                <CommandText>dbo.getSoChungTu_TCTien_TienMat</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@tiento" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@tungay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@denngay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
        </Sources>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="PCV_CLINICDataSetTongHop" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="PCV_CLINICDataSetTongHop" msprop:Generator_UserDSName="PCV_CLINICDataSetTongHop">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="getTonKho_CanhBao_HanDung" msprop:Generator_TableClassName="getTonKho_CanhBao_HanDungDataTable" msprop:Generator_TableVarName="tablegetTonKho_CanhBao_HanDung" msprop:Generator_TablePropName="getTonKho_CanhBao_HanDung" msprop:Generator_RowDeletingName="getTonKho_CanhBao_HanDungRowDeleting" msprop:Generator_RowChangingName="getTonKho_CanhBao_HanDungRowChanging" msprop:Generator_RowEvHandlerName="getTonKho_CanhBao_HanDungRowChangeEventHandler" msprop:Generator_RowDeletedName="getTonKho_CanhBao_HanDungRowDeleted" msprop:Generator_UserTableName="getTonKho_CanhBao_HanDung" msprop:Generator_RowChangedName="getTonKho_CanhBao_HanDungRowChanged" msprop:Generator_RowEvArgName="getTonKho_CanhBao_HanDungRowChangeEvent" msprop:Generator_RowClassName="getTonKho_CanhBao_HanDungRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="mahang" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnmahang" msprop:Generator_ColumnPropNameInRow="mahang" msprop:Generator_ColumnPropNameInTable="mahangColumn" msprop:Generator_UserColumnName="mahang" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tenhang" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columntenhang" msprop:Generator_ColumnPropNameInRow="tenhang" msprop:Generator_ColumnPropNameInTable="tenhangColumn" msprop:Generator_UserColumnName="tenhang" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dvt" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columndvt" msprop:Generator_ColumnPropNameInRow="dvt" msprop:Generator_ColumnPropNameInTable="dvtColumn" msprop:Generator_UserColumnName="dvt" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="quicach" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnquicach" msprop:Generator_ColumnPropNameInRow="quicach" msprop:Generator_ColumnPropNameInTable="quicachColumn" msprop:Generator_UserColumnName="quicach" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="solo" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnsolo" msprop:Generator_ColumnPropNameInRow="solo" msprop:Generator_ColumnPropNameInTable="soloColumn" msprop:Generator_UserColumnName="solo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="hsd" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnhsd" msprop:Generator_ColumnPropNameInRow="hsd" msprop:Generator_ColumnPropNameInTable="hsdColumn" msprop:Generator_UserColumnName="hsd" type="xs:dateTime" minOccurs="0" />
              <xs:element name="soluongdauky" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnsoluongdauky" msprop:Generator_ColumnPropNameInRow="soluongdauky" msprop:Generator_ColumnPropNameInTable="soluongdaukyColumn" msprop:Generator_UserColumnName="soluongdauky" type="xs:decimal" minOccurs="0" />
              <xs:element name="thanhtiendauky" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnthanhtiendauky" msprop:Generator_ColumnPropNameInRow="thanhtiendauky" msprop:Generator_ColumnPropNameInTable="thanhtiendaukyColumn" msprop:Generator_UserColumnName="thanhtiendauky" type="xs:decimal" minOccurs="0" />
              <xs:element name="soluongnhap" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnsoluongnhap" msprop:Generator_ColumnPropNameInRow="soluongnhap" msprop:Generator_ColumnPropNameInTable="soluongnhapColumn" msprop:Generator_UserColumnName="soluongnhap" type="xs:decimal" minOccurs="0" />
              <xs:element name="thanhtiennhap" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnthanhtiennhap" msprop:Generator_ColumnPropNameInRow="thanhtiennhap" msprop:Generator_ColumnPropNameInTable="thanhtiennhapColumn" msprop:Generator_UserColumnName="thanhtiennhap" type="xs:decimal" minOccurs="0" />
              <xs:element name="soluongxuat" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnsoluongxuat" msprop:Generator_ColumnPropNameInRow="soluongxuat" msprop:Generator_ColumnPropNameInTable="soluongxuatColumn" msprop:Generator_UserColumnName="soluongxuat" type="xs:decimal" minOccurs="0" />
              <xs:element name="thanhtienxuat" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnthanhtienxuat" msprop:Generator_ColumnPropNameInRow="thanhtienxuat" msprop:Generator_ColumnPropNameInTable="thanhtienxuatColumn" msprop:Generator_UserColumnName="thanhtienxuat" type="xs:decimal" minOccurs="0" />
              <xs:element name="soluongcuoiky" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnsoluongcuoiky" msprop:Generator_ColumnPropNameInRow="soluongcuoiky" msprop:Generator_ColumnPropNameInTable="soluongcuoikyColumn" msprop:Generator_UserColumnName="soluongcuoiky" type="xs:decimal" minOccurs="0" />
              <xs:element name="thanhtiencuoiky" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnthanhtiencuoiky" msprop:Generator_ColumnPropNameInRow="thanhtiencuoiky" msprop:Generator_ColumnPropNameInTable="thanhtiencuoikyColumn" msprop:Generator_UserColumnName="thanhtiencuoiky" type="xs:decimal" minOccurs="0" />
              <xs:element name="canhbaohandung" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columncanhbaohandung" msprop:Generator_ColumnPropNameInRow="canhbaohandung" msprop:Generator_ColumnPropNameInTable="canhbaohandungColumn" msprop:Generator_UserColumnName="canhbaohandung" type="xs:int" minOccurs="0" />
              <xs:element name="songayconlai" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnsongayconlai" msprop:Generator_ColumnPropNameInRow="songayconlai" msprop:Generator_ColumnPropNameInTable="songayconlaiColumn" msprop:Generator_UserColumnName="songayconlai" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="getTonKho_CanhBao_SoLuongToiDa" msprop:Generator_TableClassName="getTonKho_CanhBao_SoLuongToiDaDataTable" msprop:Generator_TableVarName="tablegetTonKho_CanhBao_SoLuongToiDa" msprop:Generator_TablePropName="getTonKho_CanhBao_SoLuongToiDa" msprop:Generator_RowDeletingName="getTonKho_CanhBao_SoLuongToiDaRowDeleting" msprop:Generator_RowChangingName="getTonKho_CanhBao_SoLuongToiDaRowChanging" msprop:Generator_RowEvHandlerName="getTonKho_CanhBao_SoLuongToiDaRowChangeEventHandler" msprop:Generator_RowDeletedName="getTonKho_CanhBao_SoLuongToiDaRowDeleted" msprop:Generator_UserTableName="getTonKho_CanhBao_SoLuongToiDa" msprop:Generator_RowChangedName="getTonKho_CanhBao_SoLuongToiDaRowChanged" msprop:Generator_RowEvArgName="getTonKho_CanhBao_SoLuongToiDaRowChangeEvent" msprop:Generator_RowClassName="getTonKho_CanhBao_SoLuongToiDaRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="mahang" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnmahang" msprop:Generator_ColumnPropNameInRow="mahang" msprop:Generator_ColumnPropNameInTable="mahangColumn" msprop:Generator_UserColumnName="mahang" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tenhang" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columntenhang" msprop:Generator_ColumnPropNameInRow="tenhang" msprop:Generator_ColumnPropNameInTable="tenhangColumn" msprop:Generator_UserColumnName="tenhang" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dvt" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columndvt" msprop:Generator_ColumnPropNameInRow="dvt" msprop:Generator_ColumnPropNameInTable="dvtColumn" msprop:Generator_UserColumnName="dvt" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="quicach" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnquicach" msprop:Generator_ColumnPropNameInRow="quicach" msprop:Generator_ColumnPropNameInTable="quicachColumn" msprop:Generator_UserColumnName="quicach" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="solo" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnsolo" msprop:Generator_ColumnPropNameInRow="solo" msprop:Generator_ColumnPropNameInTable="soloColumn" msprop:Generator_UserColumnName="solo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="hsd" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnhsd" msprop:Generator_ColumnPropNameInRow="hsd" msprop:Generator_ColumnPropNameInTable="hsdColumn" msprop:Generator_UserColumnName="hsd" type="xs:dateTime" minOccurs="0" />
              <xs:element name="soluongdauky" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnsoluongdauky" msprop:Generator_ColumnPropNameInRow="soluongdauky" msprop:Generator_ColumnPropNameInTable="soluongdaukyColumn" msprop:Generator_UserColumnName="soluongdauky" type="xs:decimal" minOccurs="0" />
              <xs:element name="thanhtiendauky" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnthanhtiendauky" msprop:Generator_ColumnPropNameInRow="thanhtiendauky" msprop:Generator_ColumnPropNameInTable="thanhtiendaukyColumn" msprop:Generator_UserColumnName="thanhtiendauky" type="xs:decimal" minOccurs="0" />
              <xs:element name="soluongnhap" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnsoluongnhap" msprop:Generator_ColumnPropNameInRow="soluongnhap" msprop:Generator_ColumnPropNameInTable="soluongnhapColumn" msprop:Generator_UserColumnName="soluongnhap" type="xs:decimal" minOccurs="0" />
              <xs:element name="thanhtiennhap" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnthanhtiennhap" msprop:Generator_ColumnPropNameInRow="thanhtiennhap" msprop:Generator_ColumnPropNameInTable="thanhtiennhapColumn" msprop:Generator_UserColumnName="thanhtiennhap" type="xs:decimal" minOccurs="0" />
              <xs:element name="soluongxuat" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnsoluongxuat" msprop:Generator_ColumnPropNameInRow="soluongxuat" msprop:Generator_ColumnPropNameInTable="soluongxuatColumn" msprop:Generator_UserColumnName="soluongxuat" type="xs:decimal" minOccurs="0" />
              <xs:element name="thanhtienxuat" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnthanhtienxuat" msprop:Generator_ColumnPropNameInRow="thanhtienxuat" msprop:Generator_ColumnPropNameInTable="thanhtienxuatColumn" msprop:Generator_UserColumnName="thanhtienxuat" type="xs:decimal" minOccurs="0" />
              <xs:element name="soluongcuoiky" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnsoluongcuoiky" msprop:Generator_ColumnPropNameInRow="soluongcuoiky" msprop:Generator_ColumnPropNameInTable="soluongcuoikyColumn" msprop:Generator_UserColumnName="soluongcuoiky" type="xs:decimal" minOccurs="0" />
              <xs:element name="thanhtiencuoiky" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnthanhtiencuoiky" msprop:Generator_ColumnPropNameInRow="thanhtiencuoiky" msprop:Generator_ColumnPropNameInTable="thanhtiencuoikyColumn" msprop:Generator_UserColumnName="thanhtiencuoiky" type="xs:decimal" minOccurs="0" />
              <xs:element name="tonkhotoida" msprop:Generator_ColumnVarNameInTable="columntonkhotoida" msprop:Generator_ColumnPropNameInRow="tonkhotoida" msprop:Generator_ColumnPropNameInTable="tonkhotoidaColumn" msprop:Generator_UserColumnName="tonkhotoida" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="getTonKho_CanhBao_SoLuongToiThieu" msprop:Generator_TableClassName="getTonKho_CanhBao_SoLuongToiThieuDataTable" msprop:Generator_TableVarName="tablegetTonKho_CanhBao_SoLuongToiThieu" msprop:Generator_TablePropName="getTonKho_CanhBao_SoLuongToiThieu" msprop:Generator_RowDeletingName="getTonKho_CanhBao_SoLuongToiThieuRowDeleting" msprop:Generator_RowChangingName="getTonKho_CanhBao_SoLuongToiThieuRowChanging" msprop:Generator_RowEvHandlerName="getTonKho_CanhBao_SoLuongToiThieuRowChangeEventHandler" msprop:Generator_RowDeletedName="getTonKho_CanhBao_SoLuongToiThieuRowDeleted" msprop:Generator_UserTableName="getTonKho_CanhBao_SoLuongToiThieu" msprop:Generator_RowChangedName="getTonKho_CanhBao_SoLuongToiThieuRowChanged" msprop:Generator_RowEvArgName="getTonKho_CanhBao_SoLuongToiThieuRowChangeEvent" msprop:Generator_RowClassName="getTonKho_CanhBao_SoLuongToiThieuRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="mahang" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnmahang" msprop:Generator_ColumnPropNameInRow="mahang" msprop:Generator_ColumnPropNameInTable="mahangColumn" msprop:Generator_UserColumnName="mahang" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tenhang" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columntenhang" msprop:Generator_ColumnPropNameInRow="tenhang" msprop:Generator_ColumnPropNameInTable="tenhangColumn" msprop:Generator_UserColumnName="tenhang" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dvt" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columndvt" msprop:Generator_ColumnPropNameInRow="dvt" msprop:Generator_ColumnPropNameInTable="dvtColumn" msprop:Generator_UserColumnName="dvt" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="quicach" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnquicach" msprop:Generator_ColumnPropNameInRow="quicach" msprop:Generator_ColumnPropNameInTable="quicachColumn" msprop:Generator_UserColumnName="quicach" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="solo" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnsolo" msprop:Generator_ColumnPropNameInRow="solo" msprop:Generator_ColumnPropNameInTable="soloColumn" msprop:Generator_UserColumnName="solo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="hsd" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnhsd" msprop:Generator_ColumnPropNameInRow="hsd" msprop:Generator_ColumnPropNameInTable="hsdColumn" msprop:Generator_UserColumnName="hsd" type="xs:dateTime" minOccurs="0" />
              <xs:element name="soluongdauky" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnsoluongdauky" msprop:Generator_ColumnPropNameInRow="soluongdauky" msprop:Generator_ColumnPropNameInTable="soluongdaukyColumn" msprop:Generator_UserColumnName="soluongdauky" type="xs:decimal" minOccurs="0" />
              <xs:element name="thanhtiendauky" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnthanhtiendauky" msprop:Generator_ColumnPropNameInRow="thanhtiendauky" msprop:Generator_ColumnPropNameInTable="thanhtiendaukyColumn" msprop:Generator_UserColumnName="thanhtiendauky" type="xs:decimal" minOccurs="0" />
              <xs:element name="soluongnhap" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnsoluongnhap" msprop:Generator_ColumnPropNameInRow="soluongnhap" msprop:Generator_ColumnPropNameInTable="soluongnhapColumn" msprop:Generator_UserColumnName="soluongnhap" type="xs:decimal" minOccurs="0" />
              <xs:element name="thanhtiennhap" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnthanhtiennhap" msprop:Generator_ColumnPropNameInRow="thanhtiennhap" msprop:Generator_ColumnPropNameInTable="thanhtiennhapColumn" msprop:Generator_UserColumnName="thanhtiennhap" type="xs:decimal" minOccurs="0" />
              <xs:element name="soluongxuat" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnsoluongxuat" msprop:Generator_ColumnPropNameInRow="soluongxuat" msprop:Generator_ColumnPropNameInTable="soluongxuatColumn" msprop:Generator_UserColumnName="soluongxuat" type="xs:decimal" minOccurs="0" />
              <xs:element name="thanhtienxuat" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnthanhtienxuat" msprop:Generator_ColumnPropNameInRow="thanhtienxuat" msprop:Generator_ColumnPropNameInTable="thanhtienxuatColumn" msprop:Generator_UserColumnName="thanhtienxuat" type="xs:decimal" minOccurs="0" />
              <xs:element name="soluongcuoiky" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnsoluongcuoiky" msprop:Generator_ColumnPropNameInRow="soluongcuoiky" msprop:Generator_ColumnPropNameInTable="soluongcuoikyColumn" msprop:Generator_UserColumnName="soluongcuoiky" type="xs:decimal" minOccurs="0" />
              <xs:element name="thanhtiencuoiky" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnthanhtiencuoiky" msprop:Generator_ColumnPropNameInRow="thanhtiencuoiky" msprop:Generator_ColumnPropNameInTable="thanhtiencuoikyColumn" msprop:Generator_UserColumnName="thanhtiencuoiky" type="xs:decimal" minOccurs="0" />
              <xs:element name="tonkhotoithieu" msprop:Generator_ColumnVarNameInTable="columntonkhotoithieu" msprop:Generator_ColumnPropNameInRow="tonkhotoithieu" msprop:Generator_ColumnPropNameInTable="tonkhotoithieuColumn" msprop:Generator_UserColumnName="tonkhotoithieu" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TCTonKho" msprop:Generator_TableClassName="TCTonKhoDataTable" msprop:Generator_TableVarName="tableTCTonKho" msprop:Generator_TablePropName="TCTonKho" msprop:Generator_RowDeletingName="TCTonKhoRowDeleting" msprop:Generator_RowChangingName="TCTonKhoRowChanging" msprop:Generator_RowEvHandlerName="TCTonKhoRowChangeEventHandler" msprop:Generator_RowDeletedName="TCTonKhoRowDeleted" msprop:Generator_UserTableName="TCTonKho" msprop:Generator_RowChangedName="TCTonKhoRowChanged" msprop:Generator_RowEvArgName="TCTonKhoRowChangeEvent" msprop:Generator_RowClassName="TCTonKhoRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ma" msprop:Generator_ColumnVarNameInTable="columnma" msprop:Generator_ColumnPropNameInRow="ma" msprop:Generator_ColumnPropNameInTable="maColumn" msprop:Generator_UserColumnName="ma">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="sochungtu" msprop:Generator_ColumnVarNameInTable="columnsochungtu" msprop:Generator_ColumnPropNameInRow="sochungtu" msprop:Generator_ColumnPropNameInTable="sochungtuColumn" msprop:Generator_UserColumnName="sochungtu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ngaychungtu" msprop:Generator_ColumnVarNameInTable="columnngaychungtu" msprop:Generator_ColumnPropNameInRow="ngaychungtu" msprop:Generator_ColumnPropNameInTable="ngaychungtuColumn" msprop:Generator_UserColumnName="ngaychungtu" type="xs:dateTime" minOccurs="0" />
              <xs:element name="sohoadon" msprop:Generator_ColumnVarNameInTable="columnsohoadon" msprop:Generator_ColumnPropNameInRow="sohoadon" msprop:Generator_ColumnPropNameInTable="sohoadonColumn" msprop:Generator_UserColumnName="sohoadon" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ngayhoadon" msprop:Generator_ColumnVarNameInTable="columnngayhoadon" msprop:Generator_ColumnPropNameInRow="ngayhoadon" msprop:Generator_ColumnPropNameInTable="ngayhoadonColumn" msprop:Generator_UserColumnName="ngayhoadon" type="xs:dateTime" minOccurs="0" />
              <xs:element name="mahang" msprop:Generator_ColumnVarNameInTable="columnmahang" msprop:Generator_ColumnPropNameInRow="mahang" msprop:Generator_ColumnPropNameInTable="mahangColumn" msprop:Generator_UserColumnName="mahang" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tenhang" msprop:Generator_ColumnVarNameInTable="columntenhang" msprop:Generator_ColumnPropNameInRow="tenhang" msprop:Generator_ColumnPropNameInTable="tenhangColumn" msprop:Generator_UserColumnName="tenhang" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="quicach" msprop:Generator_ColumnVarNameInTable="columnquicach" msprop:Generator_ColumnPropNameInRow="quicach" msprop:Generator_ColumnPropNameInTable="quicachColumn" msprop:Generator_UserColumnName="quicach" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dvt" msprop:Generator_ColumnVarNameInTable="columndvt" msprop:Generator_ColumnPropNameInRow="dvt" msprop:Generator_ColumnPropNameInTable="dvtColumn" msprop:Generator_UserColumnName="dvt" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="solo" msprop:Generator_ColumnVarNameInTable="columnsolo" msprop:Generator_ColumnPropNameInRow="solo" msprop:Generator_ColumnPropNameInTable="soloColumn" msprop:Generator_UserColumnName="solo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="sologoc" msprop:Generator_ColumnVarNameInTable="columnsologoc" msprop:Generator_ColumnPropNameInRow="sologoc" msprop:Generator_ColumnPropNameInTable="sologocColumn" msprop:Generator_UserColumnName="sologoc" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="hsd" msprop:Generator_ColumnVarNameInTable="columnhsd" msprop:Generator_ColumnPropNameInRow="hsd" msprop:Generator_ColumnPropNameInTable="hsdColumn" msprop:Generator_UserColumnName="hsd" type="xs:dateTime" minOccurs="0" />
              <xs:element name="soluongdauky" msprop:Generator_ColumnVarNameInTable="columnsoluongdauky" msprop:Generator_ColumnPropNameInRow="soluongdauky" msprop:Generator_ColumnPropNameInTable="soluongdaukyColumn" msprop:Generator_UserColumnName="soluongdauky" type="xs:decimal" minOccurs="0" />
              <xs:element name="thanhtiendauky" msprop:Generator_ColumnVarNameInTable="columnthanhtiendauky" msprop:Generator_ColumnPropNameInRow="thanhtiendauky" msprop:Generator_ColumnPropNameInTable="thanhtiendaukyColumn" msprop:Generator_UserColumnName="thanhtiendauky" type="xs:decimal" minOccurs="0" />
              <xs:element name="soluongnhap" msprop:Generator_ColumnVarNameInTable="columnsoluongnhap" msprop:Generator_ColumnPropNameInRow="soluongnhap" msprop:Generator_ColumnPropNameInTable="soluongnhapColumn" msprop:Generator_UserColumnName="soluongnhap" type="xs:decimal" minOccurs="0" />
              <xs:element name="thanhtiennhap" msprop:Generator_ColumnVarNameInTable="columnthanhtiennhap" msprop:Generator_ColumnPropNameInRow="thanhtiennhap" msprop:Generator_ColumnPropNameInTable="thanhtiennhapColumn" msprop:Generator_UserColumnName="thanhtiennhap" type="xs:decimal" minOccurs="0" />
              <xs:element name="soluongxuat" msprop:Generator_ColumnVarNameInTable="columnsoluongxuat" msprop:Generator_ColumnPropNameInRow="soluongxuat" msprop:Generator_ColumnPropNameInTable="soluongxuatColumn" msprop:Generator_UserColumnName="soluongxuat" type="xs:decimal" minOccurs="0" />
              <xs:element name="thanhtienxuat" msprop:Generator_ColumnVarNameInTable="columnthanhtienxuat" msprop:Generator_ColumnPropNameInRow="thanhtienxuat" msprop:Generator_ColumnPropNameInTable="thanhtienxuatColumn" msprop:Generator_UserColumnName="thanhtienxuat" type="xs:decimal" minOccurs="0" />
              <xs:element name="soluongcuoiky" msprop:Generator_ColumnVarNameInTable="columnsoluongcuoiky" msprop:Generator_ColumnPropNameInRow="soluongcuoiky" msprop:Generator_ColumnPropNameInTable="soluongcuoikyColumn" msprop:Generator_UserColumnName="soluongcuoiky" type="xs:decimal" minOccurs="0" />
              <xs:element name="thanhtiencuoiky" msprop:Generator_ColumnVarNameInTable="columnthanhtiencuoiky" msprop:Generator_ColumnPropNameInRow="thanhtiencuoiky" msprop:Generator_ColumnPropNameInTable="thanhtiencuoikyColumn" msprop:Generator_UserColumnName="thanhtiencuoiky" type="xs:decimal" minOccurs="0" />
              <xs:element name="mafifo" msprop:Generator_ColumnVarNameInTable="columnmafifo" msprop:Generator_ColumnPropNameInRow="mafifo" msprop:Generator_ColumnPropNameInTable="mafifoColumn" msprop:Generator_UserColumnName="mafifo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="kyketoan" msprop:Generator_ColumnVarNameInTable="columnkyketoan" msprop:Generator_ColumnPropNameInRow="kyketoan" msprop:Generator_ColumnPropNameInTable="kyketoanColumn" msprop:Generator_UserColumnName="kyketoan" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="chinhanh" msprop:Generator_ColumnVarNameInTable="columnchinhanh" msprop:Generator_ColumnPropNameInRow="chinhanh" msprop:Generator_ColumnPropNameInTable="chinhanhColumn" msprop:Generator_UserColumnName="chinhanh" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="uid" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnuid" msprop:Generator_ColumnPropNameInRow="uid" msprop:Generator_ColumnPropNameInTable="uidColumn" msprop:Generator_UserColumnName="uid" type="xs:string" minOccurs="0" />
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:decimal" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="getTCTonKho_isTonTai_DauKy" msprop:Generator_TableClassName="getTCTonKho_isTonTai_DauKyDataTable" msprop:Generator_TableVarName="tablegetTCTonKho_isTonTai_DauKy" msprop:Generator_TablePropName="getTCTonKho_isTonTai_DauKy" msprop:Generator_RowDeletingName="getTCTonKho_isTonTai_DauKyRowDeleting" msprop:Generator_RowChangingName="getTCTonKho_isTonTai_DauKyRowChanging" msprop:Generator_RowEvHandlerName="getTCTonKho_isTonTai_DauKyRowChangeEventHandler" msprop:Generator_RowDeletedName="getTCTonKho_isTonTai_DauKyRowDeleted" msprop:Generator_UserTableName="getTCTonKho_isTonTai_DauKy" msprop:Generator_RowChangedName="getTCTonKho_isTonTai_DauKyRowChanged" msprop:Generator_RowEvArgName="getTCTonKho_isTonTai_DauKyRowChangeEvent" msprop:Generator_RowClassName="getTCTonKho_isTonTai_DauKyRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Column1" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnColumn1" msprop:Generator_ColumnPropNameInRow="Column1" msprop:Generator_ColumnPropNameInTable="Column1Column" msprop:Generator_UserColumnName="Column1" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="getBHBanHangChiTiet_PhieuXuatCuoi" msprop:Generator_TableClassName="getBHBanHangChiTiet_PhieuXuatCuoiDataTable" msprop:Generator_TableVarName="tablegetBHBanHangChiTiet_PhieuXuatCuoi" msprop:Generator_TablePropName="getBHBanHangChiTiet_PhieuXuatCuoi" msprop:Generator_RowDeletingName="getBHBanHangChiTiet_PhieuXuatCuoiRowDeleting" msprop:Generator_RowChangingName="getBHBanHangChiTiet_PhieuXuatCuoiRowChanging" msprop:Generator_RowEvHandlerName="getBHBanHangChiTiet_PhieuXuatCuoiRowChangeEventHandler" msprop:Generator_RowDeletedName="getBHBanHangChiTiet_PhieuXuatCuoiRowDeleted" msprop:Generator_UserTableName="getBHBanHangChiTiet_PhieuXuatCuoi" msprop:Generator_RowChangedName="getBHBanHangChiTiet_PhieuXuatCuoiRowChanged" msprop:Generator_RowEvArgName="getBHBanHangChiTiet_PhieuXuatCuoiRowChangeEvent" msprop:Generator_RowClassName="getBHBanHangChiTiet_PhieuXuatCuoiRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ma" msprop:Generator_ColumnVarNameInTable="columnma" msprop:Generator_ColumnPropNameInRow="ma" msprop:Generator_ColumnPropNameInTable="maColumn" msprop:Generator_UserColumnName="ma">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ngaychungtu" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnngaychungtu" msprop:Generator_ColumnPropNameInRow="ngaychungtu" msprop:Generator_ColumnPropNameInTable="ngaychungtuColumn" msprop:Generator_UserColumnName="ngaychungtu" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="getTCTonKho_TonKhoTheoLo_HanDung" msprop:Generator_TableClassName="getTCTonKho_TonKhoTheoLo_HanDungDataTable" msprop:Generator_TableVarName="tablegetTCTonKho_TonKhoTheoLo_HanDung" msprop:Generator_TablePropName="getTCTonKho_TonKhoTheoLo_HanDung" msprop:Generator_RowDeletingName="getTCTonKho_TonKhoTheoLo_HanDungRowDeleting" msprop:Generator_RowChangingName="getTCTonKho_TonKhoTheoLo_HanDungRowChanging" msprop:Generator_RowEvHandlerName="getTCTonKho_TonKhoTheoLo_HanDungRowChangeEventHandler" msprop:Generator_RowDeletedName="getTCTonKho_TonKhoTheoLo_HanDungRowDeleted" msprop:Generator_UserTableName="getTCTonKho_TonKhoTheoLo_HanDung" msprop:Generator_RowChangedName="getTCTonKho_TonKhoTheoLo_HanDungRowChanged" msprop:Generator_RowEvArgName="getTCTonKho_TonKhoTheoLo_HanDungRowChangeEvent" msprop:Generator_RowClassName="getTCTonKho_TonKhoTheoLo_HanDungRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="mahang" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnmahang" msprop:Generator_ColumnPropNameInRow="mahang" msprop:Generator_ColumnPropNameInTable="mahangColumn" msprop:Generator_UserColumnName="mahang" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tenhang" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columntenhang" msprop:Generator_ColumnPropNameInRow="tenhang" msprop:Generator_ColumnPropNameInTable="tenhangColumn" msprop:Generator_UserColumnName="tenhang" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dvt" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columndvt" msprop:Generator_ColumnPropNameInRow="dvt" msprop:Generator_ColumnPropNameInTable="dvtColumn" msprop:Generator_UserColumnName="dvt" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="quicach" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnquicach" msprop:Generator_ColumnPropNameInRow="quicach" msprop:Generator_ColumnPropNameInTable="quicachColumn" msprop:Generator_UserColumnName="quicach" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="solo" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnsolo" msprop:Generator_ColumnPropNameInRow="solo" msprop:Generator_ColumnPropNameInTable="soloColumn" msprop:Generator_UserColumnName="solo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="hsd" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnhsd" msprop:Generator_ColumnPropNameInRow="hsd" msprop:Generator_ColumnPropNameInTable="hsdColumn" msprop:Generator_UserColumnName="hsd" type="xs:dateTime" minOccurs="0" />
              <xs:element name="soluongdauky" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnsoluongdauky" msprop:Generator_ColumnPropNameInRow="soluongdauky" msprop:Generator_ColumnPropNameInTable="soluongdaukyColumn" msprop:Generator_UserColumnName="soluongdauky" type="xs:decimal" minOccurs="0" />
              <xs:element name="thanhtiendauky" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnthanhtiendauky" msprop:Generator_ColumnPropNameInRow="thanhtiendauky" msprop:Generator_ColumnPropNameInTable="thanhtiendaukyColumn" msprop:Generator_UserColumnName="thanhtiendauky" type="xs:decimal" minOccurs="0" />
              <xs:element name="soluongnhap" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnsoluongnhap" msprop:Generator_ColumnPropNameInRow="soluongnhap" msprop:Generator_ColumnPropNameInTable="soluongnhapColumn" msprop:Generator_UserColumnName="soluongnhap" type="xs:decimal" minOccurs="0" />
              <xs:element name="thanhtiennhap" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnthanhtiennhap" msprop:Generator_ColumnPropNameInRow="thanhtiennhap" msprop:Generator_ColumnPropNameInTable="thanhtiennhapColumn" msprop:Generator_UserColumnName="thanhtiennhap" type="xs:decimal" minOccurs="0" />
              <xs:element name="soluongxuat" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnsoluongxuat" msprop:Generator_ColumnPropNameInRow="soluongxuat" msprop:Generator_ColumnPropNameInTable="soluongxuatColumn" msprop:Generator_UserColumnName="soluongxuat" type="xs:decimal" minOccurs="0" />
              <xs:element name="thanhtienxuat" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnthanhtienxuat" msprop:Generator_ColumnPropNameInRow="thanhtienxuat" msprop:Generator_ColumnPropNameInTable="thanhtienxuatColumn" msprop:Generator_UserColumnName="thanhtienxuat" type="xs:decimal" minOccurs="0" />
              <xs:element name="soluongcuoiky" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnsoluongcuoiky" msprop:Generator_ColumnPropNameInRow="soluongcuoiky" msprop:Generator_ColumnPropNameInTable="soluongcuoikyColumn" msprop:Generator_UserColumnName="soluongcuoiky" type="xs:decimal" minOccurs="0" />
              <xs:element name="thanhtiencuoiky" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnthanhtiencuoiky" msprop:Generator_ColumnPropNameInRow="thanhtiencuoiky" msprop:Generator_ColumnPropNameInTable="thanhtiencuoikyColumn" msprop:Generator_UserColumnName="thanhtiencuoiky" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="getTCTonKho_TonKhoTongHop" msprop:Generator_TableClassName="getTCTonKho_TonKhoTongHopDataTable" msprop:Generator_TableVarName="tablegetTCTonKho_TonKhoTongHop" msprop:Generator_TablePropName="getTCTonKho_TonKhoTongHop" msprop:Generator_RowDeletingName="getTCTonKho_TonKhoTongHopRowDeleting" msprop:Generator_RowChangingName="getTCTonKho_TonKhoTongHopRowChanging" msprop:Generator_RowEvHandlerName="getTCTonKho_TonKhoTongHopRowChangeEventHandler" msprop:Generator_RowDeletedName="getTCTonKho_TonKhoTongHopRowDeleted" msprop:Generator_UserTableName="getTCTonKho_TonKhoTongHop" msprop:Generator_RowChangedName="getTCTonKho_TonKhoTongHopRowChanged" msprop:Generator_RowEvArgName="getTCTonKho_TonKhoTongHopRowChangeEvent" msprop:Generator_RowClassName="getTCTonKho_TonKhoTongHopRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="mahang" msprop:Generator_ColumnVarNameInTable="columnmahang" msprop:Generator_ColumnPropNameInRow="mahang" msprop:Generator_ColumnPropNameInTable="mahangColumn" msprop:Generator_UserColumnName="mahang" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tenhang" msprop:Generator_ColumnVarNameInTable="columntenhang" msprop:Generator_ColumnPropNameInRow="tenhang" msprop:Generator_ColumnPropNameInTable="tenhangColumn" msprop:Generator_UserColumnName="tenhang" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dvt" msprop:Generator_ColumnVarNameInTable="columndvt" msprop:Generator_ColumnPropNameInRow="dvt" msprop:Generator_ColumnPropNameInTable="dvtColumn" msprop:Generator_UserColumnName="dvt" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="quicach" msprop:Generator_ColumnVarNameInTable="columnquicach" msprop:Generator_ColumnPropNameInRow="quicach" msprop:Generator_ColumnPropNameInTable="quicachColumn" msprop:Generator_UserColumnName="quicach" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="soluongcuoiky" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnsoluongcuoiky" msprop:Generator_ColumnPropNameInRow="soluongcuoiky" msprop:Generator_ColumnPropNameInTable="soluongcuoikyColumn" msprop:Generator_UserColumnName="soluongcuoiky" type="xs:decimal" minOccurs="0" />
              <xs:element name="thanhtiencuoiky" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnthanhtiencuoiky" msprop:Generator_ColumnPropNameInRow="thanhtiencuoiky" msprop:Generator_ColumnPropNameInTable="thanhtiencuoikyColumn" msprop:Generator_UserColumnName="thanhtiencuoiky" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="get_SoLuongCuoiKy_TonKho_Lo_HanDung_KhaDung" msprop:Generator_TableClassName="get_SoLuongCuoiKy_TonKho_Lo_HanDung_KhaDungDataTable" msprop:Generator_TableVarName="tableget_SoLuongCuoiKy_TonKho_Lo_HanDung_KhaDung" msprop:Generator_TablePropName="get_SoLuongCuoiKy_TonKho_Lo_HanDung_KhaDung" msprop:Generator_RowDeletingName="get_SoLuongCuoiKy_TonKho_Lo_HanDung_KhaDungRowDeleting" msprop:Generator_RowChangingName="get_SoLuongCuoiKy_TonKho_Lo_HanDung_KhaDungRowChanging" msprop:Generator_RowEvHandlerName="get_SoLuongCuoiKy_TonKho_Lo_HanDung_KhaDungRowChangeEventHandler" msprop:Generator_RowDeletedName="get_SoLuongCuoiKy_TonKho_Lo_HanDung_KhaDungRowDeleted" msprop:Generator_UserTableName="get_SoLuongCuoiKy_TonKho_Lo_HanDung_KhaDung" msprop:Generator_RowChangedName="get_SoLuongCuoiKy_TonKho_Lo_HanDung_KhaDungRowChanged" msprop:Generator_RowEvArgName="get_SoLuongCuoiKy_TonKho_Lo_HanDung_KhaDungRowChangeEvent" msprop:Generator_RowClassName="get_SoLuongCuoiKy_TonKho_Lo_HanDung_KhaDungRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="soluongcuoiky" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnsoluongcuoiky" msprop:Generator_ColumnPropNameInRow="soluongcuoiky" msprop:Generator_ColumnPropNameInTable="soluongcuoikyColumn" msprop:Generator_UserColumnName="soluongcuoiky" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="getSoNhatKyMuaHang" msprop:Generator_TableClassName="getSoNhatKyMuaHangDataTable" msprop:Generator_TableVarName="tablegetSoNhatKyMuaHang" msprop:Generator_RowChangedName="getSoNhatKyMuaHangRowChanged" msprop:Generator_TablePropName="getSoNhatKyMuaHang" msprop:Generator_RowDeletingName="getSoNhatKyMuaHangRowDeleting" msprop:Generator_RowChangingName="getSoNhatKyMuaHangRowChanging" msprop:Generator_RowEvHandlerName="getSoNhatKyMuaHangRowChangeEventHandler" msprop:Generator_RowDeletedName="getSoNhatKyMuaHangRowDeleted" msprop:Generator_RowClassName="getSoNhatKyMuaHangRow" msprop:Generator_UserTableName="getSoNhatKyMuaHang" msprop:Generator_RowEvArgName="getSoNhatKyMuaHangRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ma" msprop:Generator_ColumnVarNameInTable="columnma" msprop:Generator_ColumnPropNameInRow="ma" msprop:Generator_ColumnPropNameInTable="maColumn" msprop:Generator_UserColumnName="ma">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="manghiepvu" msprop:Generator_ColumnVarNameInTable="columnmanghiepvu" msprop:Generator_ColumnPropNameInRow="manghiepvu" msprop:Generator_ColumnPropNameInTable="manghiepvuColumn" msprop:Generator_UserColumnName="manghiepvu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="sochungtu" msprop:Generator_ColumnVarNameInTable="columnsochungtu" msprop:Generator_ColumnPropNameInRow="sochungtu" msprop:Generator_ColumnPropNameInTable="sochungtuColumn" msprop:Generator_UserColumnName="sochungtu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ngaychungtu" msprop:Generator_ColumnVarNameInTable="columnngaychungtu" msprop:Generator_ColumnPropNameInRow="ngaychungtu" msprop:Generator_ColumnPropNameInTable="ngaychungtuColumn" msprop:Generator_UserColumnName="ngaychungtu" type="xs:dateTime" minOccurs="0" />
              <xs:element name="taikhoanno" msprop:Generator_ColumnVarNameInTable="columntaikhoanno" msprop:Generator_ColumnPropNameInRow="taikhoanno" msprop:Generator_ColumnPropNameInTable="taikhoannoColumn" msprop:Generator_UserColumnName="taikhoanno" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="taikhoanco" msprop:Generator_ColumnVarNameInTable="columntaikhoanco" msprop:Generator_ColumnPropNameInRow="taikhoanco" msprop:Generator_ColumnPropNameInTable="taikhoancoColumn" msprop:Generator_UserColumnName="taikhoanco" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="thanhtienvnd" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnthanhtienvnd" msprop:Generator_ColumnPropNameInRow="thanhtienvnd" msprop:Generator_ColumnPropNameInTable="thanhtienvndColumn" msprop:Generator_UserColumnName="thanhtienvnd" type="xs:decimal" minOccurs="0" />
              <xs:element name="tilethueGTGT" msprop:Generator_ColumnVarNameInTable="columntilethueGTGT" msprop:Generator_ColumnPropNameInRow="tilethueGTGT" msprop:Generator_ColumnPropNameInTable="tilethueGTGTColumn" msprop:Generator_UserColumnName="tilethueGTGT" type="xs:decimal" minOccurs="0" />
              <xs:element name="tienthueGTGT" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columntienthueGTGT" msprop:Generator_ColumnPropNameInRow="tienthueGTGT" msprop:Generator_ColumnPropNameInTable="tienthueGTGTColumn" msprop:Generator_UserColumnName="tienthueGTGT" type="xs:decimal" minOccurs="0" />
              <xs:element name="taikhoanthueGTGT" msprop:Generator_ColumnVarNameInTable="columntaikhoanthueGTGT" msprop:Generator_ColumnPropNameInRow="taikhoanthueGTGT" msprop:Generator_ColumnPropNameInTable="taikhoanthueGTGTColumn" msprop:Generator_UserColumnName="taikhoanthueGTGT" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="chinhanh" msprop:Generator_ColumnVarNameInTable="columnchinhanh" msprop:Generator_ColumnPropNameInRow="chinhanh" msprop:Generator_ColumnPropNameInTable="chinhanhColumn" msprop:Generator_UserColumnName="chinhanh" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="getSoNhatKyBanHang" msprop:Generator_TableClassName="getSoNhatKyBanHangDataTable" msprop:Generator_TableVarName="tablegetSoNhatKyBanHang" msprop:Generator_TablePropName="getSoNhatKyBanHang" msprop:Generator_RowDeletingName="getSoNhatKyBanHangRowDeleting" msprop:Generator_RowChangingName="getSoNhatKyBanHangRowChanging" msprop:Generator_RowEvHandlerName="getSoNhatKyBanHangRowChangeEventHandler" msprop:Generator_RowDeletedName="getSoNhatKyBanHangRowDeleted" msprop:Generator_UserTableName="getSoNhatKyBanHang" msprop:Generator_RowChangedName="getSoNhatKyBanHangRowChanged" msprop:Generator_RowEvArgName="getSoNhatKyBanHangRowChangeEvent" msprop:Generator_RowClassName="getSoNhatKyBanHangRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ma" msprop:Generator_ColumnVarNameInTable="columnma" msprop:Generator_ColumnPropNameInRow="ma" msprop:Generator_ColumnPropNameInTable="maColumn" msprop:Generator_UserColumnName="ma">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="manghiepvu" msprop:Generator_ColumnVarNameInTable="columnmanghiepvu" msprop:Generator_ColumnPropNameInRow="manghiepvu" msprop:Generator_ColumnPropNameInTable="manghiepvuColumn" msprop:Generator_UserColumnName="manghiepvu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="sochungtu" msprop:Generator_ColumnVarNameInTable="columnsochungtu" msprop:Generator_ColumnPropNameInRow="sochungtu" msprop:Generator_ColumnPropNameInTable="sochungtuColumn" msprop:Generator_UserColumnName="sochungtu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ngaychungtu" msprop:Generator_ColumnVarNameInTable="columnngaychungtu" msprop:Generator_ColumnPropNameInRow="ngaychungtu" msprop:Generator_ColumnPropNameInTable="ngaychungtuColumn" msprop:Generator_UserColumnName="ngaychungtu" type="xs:dateTime" minOccurs="0" />
              <xs:element name="taikhoanno" msprop:Generator_ColumnVarNameInTable="columntaikhoanno" msprop:Generator_ColumnPropNameInRow="taikhoanno" msprop:Generator_ColumnPropNameInTable="taikhoannoColumn" msprop:Generator_UserColumnName="taikhoanno" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="taikhoanco" msprop:Generator_ColumnVarNameInTable="columntaikhoanco" msprop:Generator_ColumnPropNameInRow="taikhoanco" msprop:Generator_ColumnPropNameInTable="taikhoancoColumn" msprop:Generator_UserColumnName="taikhoanco" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="thanhtienvnd" msprop:Generator_ColumnVarNameInTable="columnthanhtienvnd" msprop:Generator_ColumnPropNameInRow="thanhtienvnd" msprop:Generator_ColumnPropNameInTable="thanhtienvndColumn" msprop:Generator_UserColumnName="thanhtienvnd" type="xs:decimal" minOccurs="0" />
              <xs:element name="tilethueGTGT" msprop:Generator_ColumnVarNameInTable="columntilethueGTGT" msprop:Generator_ColumnPropNameInRow="tilethueGTGT" msprop:Generator_ColumnPropNameInTable="tilethueGTGTColumn" msprop:Generator_UserColumnName="tilethueGTGT" type="xs:int" minOccurs="0" />
              <xs:element name="tienthueGTGT" msprop:Generator_ColumnVarNameInTable="columntienthueGTGT" msprop:Generator_ColumnPropNameInRow="tienthueGTGT" msprop:Generator_ColumnPropNameInTable="tienthueGTGTColumn" msprop:Generator_UserColumnName="tienthueGTGT" type="xs:decimal" minOccurs="0" />
              <xs:element name="taikhoanthueGTGT" msprop:Generator_ColumnVarNameInTable="columntaikhoanthueGTGT" msprop:Generator_ColumnPropNameInRow="taikhoanthueGTGT" msprop:Generator_ColumnPropNameInTable="taikhoanthueGTGTColumn" msprop:Generator_UserColumnName="taikhoanthueGTGT" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="chinhanh" msprop:Generator_ColumnVarNameInTable="columnchinhanh" msprop:Generator_ColumnPropNameInRow="chinhanh" msprop:Generator_ColumnPropNameInTable="chinhanhColumn" msprop:Generator_UserColumnName="chinhanh" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="getGia_BangGiaApDung" msprop:Generator_TableClassName="getGia_BangGiaApDungDataTable" msprop:Generator_TableVarName="tablegetGia_BangGiaApDung" msprop:Generator_RowChangedName="getGia_BangGiaApDungRowChanged" msprop:Generator_TablePropName="getGia_BangGiaApDung" msprop:Generator_RowDeletingName="getGia_BangGiaApDungRowDeleting" msprop:Generator_RowChangingName="getGia_BangGiaApDungRowChanging" msprop:Generator_RowEvHandlerName="getGia_BangGiaApDungRowChangeEventHandler" msprop:Generator_RowDeletedName="getGia_BangGiaApDungRowDeleted" msprop:Generator_RowClassName="getGia_BangGiaApDungRow" msprop:Generator_UserTableName="getGia_BangGiaApDung" msprop:Generator_RowEvArgName="getGia_BangGiaApDungRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="mahang" msprop:Generator_ColumnVarNameInTable="columnmahang" msprop:Generator_ColumnPropNameInRow="mahang" msprop:Generator_ColumnPropNameInTable="mahangColumn" msprop:Generator_UserColumnName="mahang" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="giaban" msprop:Generator_ColumnVarNameInTable="columngiaban" msprop:Generator_ColumnPropNameInRow="giaban" msprop:Generator_ColumnPropNameInTable="giabanColumn" msprop:Generator_UserColumnName="giaban" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="CanDoiTaiKhoan" msprop:Generator_TableClassName="CanDoiTaiKhoanDataTable" msprop:Generator_TableVarName="tableCanDoiTaiKhoan" msprop:Generator_TablePropName="CanDoiTaiKhoan" msprop:Generator_RowDeletingName="CanDoiTaiKhoanRowDeleting" msprop:Generator_RowChangingName="CanDoiTaiKhoanRowChanging" msprop:Generator_RowEvHandlerName="CanDoiTaiKhoanRowChangeEventHandler" msprop:Generator_RowDeletedName="CanDoiTaiKhoanRowDeleted" msprop:Generator_UserTableName="CanDoiTaiKhoan" msprop:Generator_RowChangedName="CanDoiTaiKhoanRowChanged" msprop:Generator_RowEvArgName="CanDoiTaiKhoanRowChangeEvent" msprop:Generator_RowClassName="CanDoiTaiKhoanRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="nodauky" msprop:Generator_ColumnVarNameInTable="columnnodauky" msprop:Generator_ColumnPropNameInRow="nodauky" msprop:Generator_ColumnPropNameInTable="nodaukyColumn" msprop:Generator_UserColumnName="nodauky" type="xs:int" />
              <xs:element name="codauky" msprop:Generator_ColumnVarNameInTable="columncodauky" msprop:Generator_ColumnPropNameInRow="codauky" msprop:Generator_ColumnPropNameInTable="codaukyColumn" msprop:Generator_UserColumnName="codauky" type="xs:int" />
              <xs:element name="psno" msprop:Generator_ColumnVarNameInTable="columnpsno" msprop:Generator_ColumnPropNameInRow="psno" msprop:Generator_ColumnPropNameInTable="psnoColumn" msprop:Generator_UserColumnName="psno" type="xs:decimal" minOccurs="0" />
              <xs:element name="psco" msprop:Generator_ColumnVarNameInTable="columnpsco" msprop:Generator_ColumnPropNameInRow="psco" msprop:Generator_ColumnPropNameInTable="pscoColumn" msprop:Generator_UserColumnName="psco" type="xs:decimal" minOccurs="0" />
              <xs:element name="nocuoiky" msprop:Generator_ColumnVarNameInTable="columnnocuoiky" msprop:Generator_ColumnPropNameInRow="nocuoiky" msprop:Generator_ColumnPropNameInTable="nocuoikyColumn" msprop:Generator_UserColumnName="nocuoiky" type="xs:int" />
              <xs:element name="cocuoiky" msprop:Generator_ColumnVarNameInTable="columncocuoiky" msprop:Generator_ColumnPropNameInRow="cocuoiky" msprop:Generator_ColumnPropNameInTable="cocuoikyColumn" msprop:Generator_UserColumnName="cocuoiky" type="xs:int" />
              <xs:element name="taikhoan" msprop:Generator_ColumnVarNameInTable="columntaikhoan" msprop:Generator_ColumnPropNameInRow="taikhoan" msprop:Generator_ColumnPropNameInTable="taikhoanColumn" msprop:Generator_UserColumnName="taikhoan" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="kyketoan" msprop:Generator_ColumnVarNameInTable="columnkyketoan" msprop:Generator_ColumnPropNameInRow="kyketoan" msprop:Generator_ColumnPropNameInTable="kyketoanColumn" msprop:Generator_UserColumnName="kyketoan" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="chinhanh" msprop:Generator_ColumnVarNameInTable="columnchinhanh" msprop:Generator_ColumnPropNameInRow="chinhanh" msprop:Generator_ColumnPropNameInTable="chinhanhColumn" msprop:Generator_UserColumnName="chinhanh" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tentaikhoan" msprop:Generator_ColumnVarNameInTable="columntentaikhoan" msprop:Generator_ColumnPropNameInRow="tentaikhoan" msprop:Generator_ColumnPropNameInTable="tentaikhoanColumn" msprop:Generator_UserColumnName="tentaikhoan">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cap" msprop:Generator_ColumnVarNameInTable="columncap" msprop:Generator_ColumnPropNameInRow="cap" msprop:Generator_ColumnPropNameInTable="capColumn" msprop:Generator_UserColumnName="cap" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TonQuy" msprop:Generator_TableClassName="TonQuyDataTable" msprop:Generator_TableVarName="tableTonQuy" msprop:Generator_TablePropName="TonQuy" msprop:Generator_RowDeletingName="TonQuyRowDeleting" msprop:Generator_RowChangingName="TonQuyRowChanging" msprop:Generator_RowEvHandlerName="TonQuyRowChangeEventHandler" msprop:Generator_RowDeletedName="TonQuyRowDeleted" msprop:Generator_UserTableName="TonQuy" msprop:Generator_RowChangedName="TonQuyRowChanged" msprop:Generator_RowEvArgName="TonQuyRowChangeEvent" msprop:Generator_RowClassName="TonQuyRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="sochungtu" msprop:Generator_ColumnVarNameInTable="columnsochungtu" msprop:Generator_ColumnPropNameInRow="sochungtu" msprop:Generator_ColumnPropNameInTable="sochungtuColumn" msprop:Generator_UserColumnName="sochungtu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ngaychungtu" msprop:Generator_ColumnVarNameInTable="columnngaychungtu" msprop:Generator_ColumnPropNameInRow="ngaychungtu" msprop:Generator_ColumnPropNameInTable="ngaychungtuColumn" msprop:Generator_UserColumnName="ngaychungtu" type="xs:dateTime" minOccurs="0" />
              <xs:element name="taikhoan" msprop:Generator_ColumnVarNameInTable="columntaikhoan" msprop:Generator_ColumnPropNameInRow="taikhoan" msprop:Generator_ColumnPropNameInTable="taikhoanColumn" msprop:Generator_UserColumnName="taikhoan" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="phatsinhco" msprop:Generator_ColumnVarNameInTable="columnphatsinhco" msprop:Generator_ColumnPropNameInRow="phatsinhco" msprop:Generator_ColumnPropNameInTable="phatsinhcoColumn" msprop:Generator_UserColumnName="phatsinhco" type="xs:decimal" minOccurs="0" />
              <xs:element name="phatsinhno" msprop:Generator_ColumnVarNameInTable="columnphatsinhno" msprop:Generator_ColumnPropNameInRow="phatsinhno" msprop:Generator_ColumnPropNameInTable="phatsinhnoColumn" msprop:Generator_UserColumnName="phatsinhno" type="xs:decimal" minOccurs="0" />
              <xs:element name="chinhanh" msprop:Generator_ColumnVarNameInTable="columnchinhanh" msprop:Generator_ColumnPropNameInRow="chinhanh" msprop:Generator_ColumnPropNameInTable="chinhanhColumn" msprop:Generator_UserColumnName="chinhanh" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cap" msprop:Generator_ColumnVarNameInTable="columncap" msprop:Generator_ColumnPropNameInRow="cap" msprop:Generator_ColumnPropNameInTable="capColumn" msprop:Generator_UserColumnName="cap" type="xs:int" minOccurs="0" />
              <xs:element name="kyketoan" msprop:Generator_ColumnVarNameInTable="columnkyketoan" msprop:Generator_ColumnPropNameInRow="kyketoan" msprop:Generator_ColumnPropNameInTable="kyketoanColumn" msprop:Generator_UserColumnName="kyketoan" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="getTCCongNo_PhaiThu" msprop:Generator_TableClassName="getTCCongNo_PhaiThuDataTable" msprop:Generator_TableVarName="tablegetTCCongNo_PhaiThu" msprop:Generator_RowChangedName="getTCCongNo_PhaiThuRowChanged" msprop:Generator_TablePropName="getTCCongNo_PhaiThu" msprop:Generator_RowDeletingName="getTCCongNo_PhaiThuRowDeleting" msprop:Generator_RowChangingName="getTCCongNo_PhaiThuRowChanging" msprop:Generator_RowEvHandlerName="getTCCongNo_PhaiThuRowChangeEventHandler" msprop:Generator_RowDeletedName="getTCCongNo_PhaiThuRowDeleted" msprop:Generator_RowClassName="getTCCongNo_PhaiThuRow" msprop:Generator_UserTableName="getTCCongNo_PhaiThu" msprop:Generator_RowEvArgName="getTCCongNo_PhaiThuRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ma" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnma" msprop:Generator_ColumnPropNameInRow="ma" msprop:Generator_ColumnPropNameInTable="maColumn" msprop:Generator_UserColumnName="ma" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ten" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnten" msprop:Generator_ColumnPropNameInRow="ten" msprop:Generator_ColumnPropNameInTable="tenColumn" msprop:Generator_UserColumnName="ten" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="diachi" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columndiachi" msprop:Generator_ColumnPropNameInRow="diachi" msprop:Generator_ColumnPropNameInTable="diachiColumn" msprop:Generator_UserColumnName="diachi" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nodauky" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnnodauky" msprop:Generator_ColumnPropNameInRow="nodauky" msprop:Generator_ColumnPropNameInTable="nodaukyColumn" msprop:Generator_UserColumnName="nodauky" type="xs:decimal" minOccurs="0" />
              <xs:element name="phatsinhno" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnphatsinhno" msprop:Generator_ColumnPropNameInRow="phatsinhno" msprop:Generator_ColumnPropNameInTable="phatsinhnoColumn" msprop:Generator_UserColumnName="phatsinhno" type="xs:decimal" minOccurs="0" />
              <xs:element name="phatsinhco" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnphatsinhco" msprop:Generator_ColumnPropNameInRow="phatsinhco" msprop:Generator_ColumnPropNameInTable="phatsinhcoColumn" msprop:Generator_UserColumnName="phatsinhco" type="xs:decimal" minOccurs="0" />
              <xs:element name="nocuoiky" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnnocuoiky" msprop:Generator_ColumnPropNameInRow="nocuoiky" msprop:Generator_ColumnPropNameInTable="nocuoikyColumn" msprop:Generator_UserColumnName="nocuoiky" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="getTCCongNo_PhaiTra" msprop:Generator_TableClassName="getTCCongNo_PhaiTraDataTable" msprop:Generator_TableVarName="tablegetTCCongNo_PhaiTra" msprop:Generator_RowChangedName="getTCCongNo_PhaiTraRowChanged" msprop:Generator_TablePropName="getTCCongNo_PhaiTra" msprop:Generator_RowDeletingName="getTCCongNo_PhaiTraRowDeleting" msprop:Generator_RowChangingName="getTCCongNo_PhaiTraRowChanging" msprop:Generator_RowEvHandlerName="getTCCongNo_PhaiTraRowChangeEventHandler" msprop:Generator_RowDeletedName="getTCCongNo_PhaiTraRowDeleted" msprop:Generator_RowClassName="getTCCongNo_PhaiTraRow" msprop:Generator_UserTableName="getTCCongNo_PhaiTra" msprop:Generator_RowEvArgName="getTCCongNo_PhaiTraRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ma" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnma" msprop:Generator_ColumnPropNameInRow="ma" msprop:Generator_ColumnPropNameInTable="maColumn" msprop:Generator_UserColumnName="ma" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ten" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnten" msprop:Generator_ColumnPropNameInRow="ten" msprop:Generator_ColumnPropNameInTable="tenColumn" msprop:Generator_UserColumnName="ten" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="diachi" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columndiachi" msprop:Generator_ColumnPropNameInRow="diachi" msprop:Generator_ColumnPropNameInTable="diachiColumn" msprop:Generator_UserColumnName="diachi" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nodauky" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnnodauky" msprop:Generator_ColumnPropNameInRow="nodauky" msprop:Generator_ColumnPropNameInTable="nodaukyColumn" msprop:Generator_UserColumnName="nodauky" type="xs:decimal" minOccurs="0" />
              <xs:element name="phatsinhno" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnphatsinhno" msprop:Generator_ColumnPropNameInRow="phatsinhno" msprop:Generator_ColumnPropNameInTable="phatsinhnoColumn" msprop:Generator_UserColumnName="phatsinhno" type="xs:decimal" minOccurs="0" />
              <xs:element name="phatsinhco" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnphatsinhco" msprop:Generator_ColumnPropNameInRow="phatsinhco" msprop:Generator_ColumnPropNameInTable="phatsinhcoColumn" msprop:Generator_UserColumnName="phatsinhco" type="xs:decimal" minOccurs="0" />
              <xs:element name="nocuoiky" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnnocuoiky" msprop:Generator_ColumnPropNameInRow="nocuoiky" msprop:Generator_ColumnPropNameInTable="nocuoikyColumn" msprop:Generator_UserColumnName="nocuoiky" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="getHoSoBenhNhan" msprop:Generator_TableClassName="getHoSoBenhNhanDataTable" msprop:Generator_TableVarName="tablegetHoSoBenhNhan" msprop:Generator_TablePropName="getHoSoBenhNhan" msprop:Generator_RowDeletingName="getHoSoBenhNhanRowDeleting" msprop:Generator_RowChangingName="getHoSoBenhNhanRowChanging" msprop:Generator_RowEvHandlerName="getHoSoBenhNhanRowChangeEventHandler" msprop:Generator_RowDeletedName="getHoSoBenhNhanRowDeleted" msprop:Generator_UserTableName="getHoSoBenhNhan" msprop:Generator_RowChangedName="getHoSoBenhNhanRowChanged" msprop:Generator_RowEvArgName="getHoSoBenhNhanRowChangeEvent" msprop:Generator_RowClassName="getHoSoBenhNhanRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ma" msprop:Generator_ColumnVarNameInTable="columnma" msprop:Generator_ColumnPropNameInRow="ma" msprop:Generator_ColumnPropNameInTable="maColumn" msprop:Generator_UserColumnName="ma">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="sotiepnhan" msprop:Generator_ColumnVarNameInTable="columnsotiepnhan" msprop:Generator_ColumnPropNameInRow="sotiepnhan" msprop:Generator_ColumnPropNameInTable="sotiepnhanColumn" msprop:Generator_UserColumnName="sotiepnhan" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ngaytiepnhan" msprop:Generator_ColumnVarNameInTable="columnngaytiepnhan" msprop:Generator_ColumnPropNameInRow="ngaytiepnhan" msprop:Generator_ColumnPropNameInTable="ngaytiepnhanColumn" msprop:Generator_UserColumnName="ngaytiepnhan" type="xs:dateTime" minOccurs="0" />
              <xs:element name="loaibenhnhan" msprop:Generator_ColumnVarNameInTable="columnloaibenhnhan" msprop:Generator_ColumnPropNameInRow="loaibenhnhan" msprop:Generator_ColumnPropNameInTable="loaibenhnhanColumn" msprop:Generator_UserColumnName="loaibenhnhan" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="mabenhnhan" msprop:Generator_ColumnVarNameInTable="columnmabenhnhan" msprop:Generator_ColumnPropNameInRow="mabenhnhan" msprop:Generator_ColumnPropNameInTable="mabenhnhanColumn" msprop:Generator_UserColumnName="mabenhnhan" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ten" msprop:Generator_ColumnVarNameInTable="columnten" msprop:Generator_ColumnPropNameInRow="ten" msprop:Generator_ColumnPropNameInTable="tenColumn" msprop:Generator_UserColumnName="ten" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tuoi" msprop:Generator_ColumnVarNameInTable="columntuoi" msprop:Generator_ColumnPropNameInRow="tuoi" msprop:Generator_ColumnPropNameInTable="tuoiColumn" msprop:Generator_UserColumnName="tuoi" type="xs:int" minOccurs="0" />
              <xs:element name="namsinh" msprop:Generator_ColumnVarNameInTable="columnnamsinh" msprop:Generator_ColumnPropNameInRow="namsinh" msprop:Generator_ColumnPropNameInTable="namsinhColumn" msprop:Generator_UserColumnName="namsinh" type="xs:int" minOccurs="0" />
              <xs:element name="gioitinh" msprop:Generator_ColumnVarNameInTable="columngioitinh" msprop:Generator_ColumnPropNameInRow="gioitinh" msprop:Generator_ColumnPropNameInTable="gioitinhColumn" msprop:Generator_UserColumnName="gioitinh" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dantoc" msprop:Generator_ColumnVarNameInTable="columndantoc" msprop:Generator_ColumnPropNameInRow="dantoc" msprop:Generator_ColumnPropNameInTable="dantocColumn" msprop:Generator_UserColumnName="dantoc" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="diachi" msprop:Generator_ColumnVarNameInTable="columndiachi" msprop:Generator_ColumnPropNameInRow="diachi" msprop:Generator_ColumnPropNameInTable="diachiColumn" msprop:Generator_UserColumnName="diachi" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="sobhyt" msprop:Generator_ColumnVarNameInTable="columnsobhyt" msprop:Generator_ColumnPropNameInRow="sobhyt" msprop:Generator_ColumnPropNameInTable="sobhytColumn" msprop:Generator_UserColumnName="sobhyt" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="traituyen" msprop:Generator_ColumnVarNameInTable="columntraituyen" msprop:Generator_ColumnPropNameInRow="traituyen" msprop:Generator_ColumnPropNameInTable="traituyenColumn" msprop:Generator_UserColumnName="traituyen" type="xs:boolean" minOccurs="0" />
              <xs:element name="ngaybatdau" msprop:Generator_ColumnVarNameInTable="columnngaybatdau" msprop:Generator_ColumnPropNameInRow="ngaybatdau" msprop:Generator_ColumnPropNameInTable="ngaybatdauColumn" msprop:Generator_UserColumnName="ngaybatdau" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ngayhethan" msprop:Generator_ColumnVarNameInTable="columnngayhethan" msprop:Generator_ColumnPropNameInRow="ngayhethan" msprop:Generator_ColumnPropNameInTable="ngayhethanColumn" msprop:Generator_UserColumnName="ngayhethan" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ngaythangnamsinh" msprop:Generator_ColumnVarNameInTable="columnngaythangnamsinh" msprop:Generator_ColumnPropNameInRow="ngaythangnamsinh" msprop:Generator_ColumnPropNameInTable="ngaythangnamsinhColumn" msprop:Generator_UserColumnName="ngaythangnamsinh" type="xs:dateTime" minOccurs="0" />
              <xs:element name="noicongtac" msprop:Generator_ColumnVarNameInTable="columnnoicongtac" msprop:Generator_ColumnPropNameInRow="noicongtac" msprop:Generator_ColumnPropNameInTable="noicongtacColumn" msprop:Generator_UserColumnName="noicongtac" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nghenghiep" msprop:Generator_ColumnVarNameInTable="columnnghenghiep" msprop:Generator_ColumnPropNameInRow="nghenghiep" msprop:Generator_ColumnPropNameInTable="nghenghiepColumn" msprop:Generator_UserColumnName="nghenghiep" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="quocgia" msprop:Generator_ColumnVarNameInTable="columnquocgia" msprop:Generator_ColumnPropNameInRow="quocgia" msprop:Generator_ColumnPropNameInTable="quocgiaColumn" msprop:Generator_UserColumnName="quocgia" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tinhthanh" msprop:Generator_ColumnVarNameInTable="columntinhthanh" msprop:Generator_ColumnPropNameInRow="tinhthanh" msprop:Generator_ColumnPropNameInTable="tinhthanhColumn" msprop:Generator_UserColumnName="tinhthanh" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="quanhuyen" msprop:Generator_ColumnVarNameInTable="columnquanhuyen" msprop:Generator_ColumnPropNameInRow="quanhuyen" msprop:Generator_ColumnPropNameInTable="quanhuyenColumn" msprop:Generator_UserColumnName="quanhuyen" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="phuongxa" msprop:Generator_ColumnVarNameInTable="columnphuongxa" msprop:Generator_ColumnPropNameInRow="phuongxa" msprop:Generator_ColumnPropNameInTable="phuongxaColumn" msprop:Generator_UserColumnName="phuongxa" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="thonphoduong" msprop:Generator_ColumnVarNameInTable="columnthonphoduong" msprop:Generator_ColumnPropNameInRow="thonphoduong" msprop:Generator_ColumnPropNameInTable="thonphoduongColumn" msprop:Generator_UserColumnName="thonphoduong" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="sonha" msprop:Generator_ColumnVarNameInTable="columnsonha" msprop:Generator_ColumnPropNameInRow="sonha" msprop:Generator_ColumnPropNameInTable="sonhaColumn" msprop:Generator_UserColumnName="sonha" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="uutien" msprop:Generator_ColumnVarNameInTable="columnuutien" msprop:Generator_ColumnPropNameInRow="uutien" msprop:Generator_ColumnPropNameInTable="uutienColumn" msprop:Generator_UserColumnName="uutien" type="xs:boolean" minOccurs="0" />
              <xs:element name="dienthoai" msprop:Generator_ColumnVarNameInTable="columndienthoai" msprop:Generator_ColumnPropNameInRow="dienthoai" msprop:Generator_ColumnPropNameInTable="dienthoaiColumn" msprop:Generator_UserColumnName="dienthoai" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="email" msprop:Generator_ColumnVarNameInTable="columnemail" msprop:Generator_ColumnPropNameInRow="email" msprop:Generator_ColumnPropNameInTable="emailColumn" msprop:Generator_UserColumnName="email" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="noigioithieu" msprop:Generator_ColumnVarNameInTable="columnnoigioithieu" msprop:Generator_ColumnPropNameInRow="noigioithieu" msprop:Generator_ColumnPropNameInTable="noigioithieuColumn" msprop:Generator_UserColumnName="noigioithieu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="chandoansobo" msprop:Generator_ColumnVarNameInTable="columnchandoansobo" msprop:Generator_ColumnPropNameInRow="chandoansobo" msprop:Generator_ColumnPropNameInTable="chandoansoboColumn" msprop:Generator_UserColumnName="chandoansobo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="lydokham" msprop:Generator_ColumnVarNameInTable="columnlydokham" msprop:Generator_ColumnPropNameInRow="lydokham" msprop:Generator_ColumnPropNameInTable="lydokhamColumn" msprop:Generator_UserColumnName="lydokham" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="chonkham" msprop:Generator_ColumnVarNameInTable="columnchonkham" msprop:Generator_ColumnPropNameInRow="chonkham" msprop:Generator_ColumnPropNameInTable="chonkhamColumn" msprop:Generator_UserColumnName="chonkham" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="bacsi" msprop:Generator_ColumnVarNameInTable="columnbacsi" msprop:Generator_ColumnPropNameInRow="bacsi" msprop:Generator_ColumnPropNameInTable="bacsiColumn" msprop:Generator_UserColumnName="bacsi" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="phong" msprop:Generator_ColumnVarNameInTable="columnphong" msprop:Generator_ColumnPropNameInRow="phong" msprop:Generator_ColumnPropNameInTable="phongColumn" msprop:Generator_UserColumnName="phong" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ngaykhamgannhat" msprop:Generator_ColumnVarNameInTable="columnngaykhamgannhat" msprop:Generator_ColumnPropNameInRow="ngaykhamgannhat" msprop:Generator_ColumnPropNameInTable="ngaykhamgannhatColumn" msprop:Generator_UserColumnName="ngaykhamgannhat" type="xs:dateTime" minOccurs="0" />
              <xs:element name="solanden" msprop:Generator_ColumnVarNameInTable="columnsolanden" msprop:Generator_ColumnPropNameInRow="solanden" msprop:Generator_ColumnPropNameInTable="solandenColumn" msprop:Generator_UserColumnName="solanden" type="xs:int" minOccurs="0" />
              <xs:element name="solannamvien" msprop:Generator_ColumnVarNameInTable="columnsolannamvien" msprop:Generator_ColumnPropNameInRow="solannamvien" msprop:Generator_ColumnPropNameInTable="solannamvienColumn" msprop:Generator_UserColumnName="solannamvien" type="xs:int" minOccurs="0" />
              <xs:element name="ghichu" msprop:Generator_ColumnVarNameInTable="columnghichu" msprop:Generator_ColumnPropNameInRow="ghichu" msprop:Generator_ColumnPropNameInTable="ghichuColumn" msprop:Generator_UserColumnName="ghichu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tinhtrang" msprop:Generator_ColumnVarNameInTable="columntinhtrang" msprop:Generator_ColumnPropNameInRow="tinhtrang" msprop:Generator_ColumnPropNameInTable="tinhtrangColumn" msprop:Generator_UserColumnName="tinhtrang" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="chinhanh" msprop:Generator_ColumnVarNameInTable="columnchinhanh" msprop:Generator_ColumnPropNameInRow="chinhanh" msprop:Generator_ColumnPropNameInTable="chinhanhColumn" msprop:Generator_UserColumnName="chinhanh" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="getHoSoChuyenVien" msprop:Generator_TableClassName="getHoSoChuyenVienDataTable" msprop:Generator_TableVarName="tablegetHoSoChuyenVien" msprop:Generator_TablePropName="getHoSoChuyenVien" msprop:Generator_RowDeletingName="getHoSoChuyenVienRowDeleting" msprop:Generator_RowChangingName="getHoSoChuyenVienRowChanging" msprop:Generator_RowEvHandlerName="getHoSoChuyenVienRowChangeEventHandler" msprop:Generator_RowDeletedName="getHoSoChuyenVienRowDeleted" msprop:Generator_UserTableName="getHoSoChuyenVien" msprop:Generator_RowChangedName="getHoSoChuyenVienRowChanged" msprop:Generator_RowEvArgName="getHoSoChuyenVienRowChangeEvent" msprop:Generator_RowClassName="getHoSoChuyenVienRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ma" msprop:Generator_ColumnVarNameInTable="columnma" msprop:Generator_ColumnPropNameInRow="ma" msprop:Generator_ColumnPropNameInTable="maColumn" msprop:Generator_UserColumnName="ma">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="sophieu" msprop:Generator_ColumnVarNameInTable="columnsophieu" msprop:Generator_ColumnPropNameInRow="sophieu" msprop:Generator_ColumnPropNameInTable="sophieuColumn" msprop:Generator_UserColumnName="sophieu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="mabenhnhan" msprop:Generator_ColumnVarNameInTable="columnmabenhnhan" msprop:Generator_ColumnPropNameInRow="mabenhnhan" msprop:Generator_ColumnPropNameInTable="mabenhnhanColumn" msprop:Generator_UserColumnName="mabenhnhan" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tenbenhnhan" msprop:Generator_ColumnVarNameInTable="columntenbenhnhan" msprop:Generator_ColumnPropNameInRow="tenbenhnhan" msprop:Generator_ColumnPropNameInTable="tenbenhnhanColumn" msprop:Generator_UserColumnName="tenbenhnhan" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="benhvien" msprop:Generator_ColumnVarNameInTable="columnbenhvien" msprop:Generator_ColumnPropNameInRow="benhvien" msprop:Generator_ColumnPropNameInTable="benhvienColumn" msprop:Generator_UserColumnName="benhvien" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tenbenhvien" msprop:Generator_ColumnVarNameInTable="columntenbenhvien" msprop:Generator_ColumnPropNameInRow="tenbenhvien" msprop:Generator_ColumnPropNameInTable="tenbenhvienColumn" msprop:Generator_UserColumnName="tenbenhvien" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="diachibenhvien" msprop:Generator_ColumnVarNameInTable="columndiachibenhvien" msprop:Generator_ColumnPropNameInRow="diachibenhvien" msprop:Generator_ColumnPropNameInTable="diachibenhvienColumn" msprop:Generator_UserColumnName="diachibenhvien" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dauhieulamsang" msprop:Generator_ColumnVarNameInTable="columndauhieulamsang" msprop:Generator_ColumnPropNameInRow="dauhieulamsang" msprop:Generator_ColumnPropNameInTable="dauhieulamsangColumn" msprop:Generator_UserColumnName="dauhieulamsang" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cacxetnghiem" msprop:Generator_ColumnVarNameInTable="columncacxetnghiem" msprop:Generator_ColumnPropNameInRow="cacxetnghiem" msprop:Generator_ColumnPropNameInTable="cacxetnghiemColumn" msprop:Generator_UserColumnName="cacxetnghiem" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="chandoan" msprop:Generator_ColumnVarNameInTable="columnchandoan" msprop:Generator_ColumnPropNameInRow="chandoan" msprop:Generator_ColumnPropNameInTable="chandoanColumn" msprop:Generator_UserColumnName="chandoan" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="thuocdadung" msprop:Generator_ColumnVarNameInTable="columnthuocdadung" msprop:Generator_ColumnPropNameInRow="thuocdadung" msprop:Generator_ColumnPropNameInTable="thuocdadungColumn" msprop:Generator_UserColumnName="thuocdadung" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tinhtrangnguoibenh" msprop:Generator_ColumnVarNameInTable="columntinhtrangnguoibenh" msprop:Generator_ColumnPropNameInRow="tinhtrangnguoibenh" msprop:Generator_ColumnPropNameInTable="tinhtrangnguoibenhColumn" msprop:Generator_UserColumnName="tinhtrangnguoibenh" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="lydochuyenvien" msprop:Generator_ColumnVarNameInTable="columnlydochuyenvien" msprop:Generator_ColumnPropNameInRow="lydochuyenvien" msprop:Generator_ColumnPropNameInTable="lydochuyenvienColumn" msprop:Generator_UserColumnName="lydochuyenvien" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="phuongtienvanchuyen" msprop:Generator_ColumnVarNameInTable="columnphuongtienvanchuyen" msprop:Generator_ColumnPropNameInRow="phuongtienvanchuyen" msprop:Generator_ColumnPropNameInTable="phuongtienvanchuyenColumn" msprop:Generator_UserColumnName="phuongtienvanchuyen" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nguoiduadi" msprop:Generator_ColumnVarNameInTable="columnnguoiduadi" msprop:Generator_ColumnPropNameInRow="nguoiduadi" msprop:Generator_ColumnPropNameInTable="nguoiduadiColumn" msprop:Generator_UserColumnName="nguoiduadi" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="getHoSoSinhHieu" msprop:Generator_TableClassName="getHoSoSinhHieuDataTable" msprop:Generator_TableVarName="tablegetHoSoSinhHieu" msprop:Generator_TablePropName="getHoSoSinhHieu" msprop:Generator_RowDeletingName="getHoSoSinhHieuRowDeleting" msprop:Generator_RowChangingName="getHoSoSinhHieuRowChanging" msprop:Generator_RowEvHandlerName="getHoSoSinhHieuRowChangeEventHandler" msprop:Generator_RowDeletedName="getHoSoSinhHieuRowDeleted" msprop:Generator_UserTableName="getHoSoSinhHieu" msprop:Generator_RowChangedName="getHoSoSinhHieuRowChanged" msprop:Generator_RowEvArgName="getHoSoSinhHieuRowChangeEvent" msprop:Generator_RowClassName="getHoSoSinhHieuRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ma" msprop:Generator_ColumnVarNameInTable="columnma" msprop:Generator_ColumnPropNameInRow="ma" msprop:Generator_ColumnPropNameInTable="maColumn" msprop:Generator_UserColumnName="ma">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="masophieu" msprop:Generator_ColumnVarNameInTable="columnmasophieu" msprop:Generator_ColumnPropNameInRow="masophieu" msprop:Generator_ColumnPropNameInTable="masophieuColumn" msprop:Generator_UserColumnName="masophieu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="mabenhnhan" msprop:Generator_ColumnVarNameInTable="columnmabenhnhan" msprop:Generator_ColumnPropNameInRow="mabenhnhan" msprop:Generator_ColumnPropNameInTable="mabenhnhanColumn" msprop:Generator_UserColumnName="mabenhnhan" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ten" msprop:Generator_ColumnVarNameInTable="columnten" msprop:Generator_ColumnPropNameInRow="ten" msprop:Generator_ColumnPropNameInTable="tenColumn" msprop:Generator_UserColumnName="ten" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="gioitinh" msprop:Generator_ColumnVarNameInTable="columngioitinh" msprop:Generator_ColumnPropNameInRow="gioitinh" msprop:Generator_ColumnPropNameInTable="gioitinhColumn" msprop:Generator_UserColumnName="gioitinh" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ngaysinh" msprop:Generator_ColumnVarNameInTable="columnngaysinh" msprop:Generator_ColumnPropNameInRow="ngaysinh" msprop:Generator_ColumnPropNameInTable="ngaysinhColumn" msprop:Generator_UserColumnName="ngaysinh" type="xs:dateTime" minOccurs="0" />
              <xs:element name="tuoi" msprop:Generator_ColumnVarNameInTable="columntuoi" msprop:Generator_ColumnPropNameInRow="tuoi" msprop:Generator_ColumnPropNameInTable="tuoiColumn" msprop:Generator_UserColumnName="tuoi" type="xs:int" minOccurs="0" />
              <xs:element name="sobhyt" msprop:Generator_ColumnVarNameInTable="columnsobhyt" msprop:Generator_ColumnPropNameInRow="sobhyt" msprop:Generator_ColumnPropNameInTable="sobhytColumn" msprop:Generator_UserColumnName="sobhyt" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="hanbhyt" msprop:Generator_ColumnVarNameInTable="columnhanbhyt" msprop:Generator_ColumnPropNameInRow="hanbhyt" msprop:Generator_ColumnPropNameInTable="hanbhytColumn" msprop:Generator_UserColumnName="hanbhyt" type="xs:dateTime" minOccurs="0" />
              <xs:element name="diachi" msprop:Generator_ColumnVarNameInTable="columndiachi" msprop:Generator_ColumnPropNameInRow="diachi" msprop:Generator_ColumnPropNameInTable="diachiColumn" msprop:Generator_UserColumnName="diachi" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ngaydo" msprop:Generator_ColumnVarNameInTable="columnngaydo" msprop:Generator_ColumnPropNameInRow="ngaydo" msprop:Generator_ColumnPropNameInTable="ngaydoColumn" msprop:Generator_UserColumnName="ngaydo" type="xs:dateTime" minOccurs="0" />
              <xs:element name="mach" msprop:Generator_ColumnVarNameInTable="columnmach" msprop:Generator_ColumnPropNameInRow="mach" msprop:Generator_ColumnPropNameInTable="machColumn" msprop:Generator_UserColumnName="mach" type="xs:int" minOccurs="0" />
              <xs:element name="nhietdo" msprop:Generator_ColumnVarNameInTable="columnnhietdo" msprop:Generator_ColumnPropNameInRow="nhietdo" msprop:Generator_ColumnPropNameInTable="nhietdoColumn" msprop:Generator_UserColumnName="nhietdo" type="xs:int" minOccurs="0" />
              <xs:element name="huyetap" msprop:Generator_ColumnVarNameInTable="columnhuyetap" msprop:Generator_ColumnPropNameInRow="huyetap" msprop:Generator_ColumnPropNameInTable="huyetapColumn" msprop:Generator_UserColumnName="huyetap" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nhiptho" msprop:Generator_ColumnVarNameInTable="columnnhiptho" msprop:Generator_ColumnPropNameInRow="nhiptho" msprop:Generator_ColumnPropNameInTable="nhipthoColumn" msprop:Generator_UserColumnName="nhiptho" type="xs:int" minOccurs="0" />
              <xs:element name="cannang" msprop:Generator_ColumnVarNameInTable="columncannang" msprop:Generator_ColumnPropNameInRow="cannang" msprop:Generator_ColumnPropNameInTable="cannangColumn" msprop:Generator_UserColumnName="cannang" type="xs:int" minOccurs="0" />
              <xs:element name="chieucao" msprop:Generator_ColumnVarNameInTable="columnchieucao" msprop:Generator_ColumnPropNameInRow="chieucao" msprop:Generator_ColumnPropNameInTable="chieucaoColumn" msprop:Generator_UserColumnName="chieucao" type="xs:int" minOccurs="0" />
              <xs:element name="vongbung" msprop:Generator_ColumnVarNameInTable="columnvongbung" msprop:Generator_ColumnPropNameInRow="vongbung" msprop:Generator_ColumnPropNameInTable="vongbungColumn" msprop:Generator_UserColumnName="vongbung" type="xs:int" minOccurs="0" />
              <xs:element name="bmi" msprop:Generator_ColumnVarNameInTable="columnbmi" msprop:Generator_ColumnPropNameInRow="bmi" msprop:Generator_ColumnPropNameInTable="bmiColumn" msprop:Generator_UserColumnName="bmi" type="xs:decimal" minOccurs="0" />
              <xs:element name="ghichu" msprop:Generator_ColumnVarNameInTable="columnghichu" msprop:Generator_ColumnPropNameInRow="ghichu" msprop:Generator_ColumnPropNameInTable="ghichuColumn" msprop:Generator_UserColumnName="ghichu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tinhtrang" msprop:Generator_ColumnVarNameInTable="columntinhtrang" msprop:Generator_ColumnPropNameInRow="tinhtrang" msprop:Generator_ColumnPropNameInTable="tinhtrangColumn" msprop:Generator_UserColumnName="tinhtrang" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="chinhanh" msprop:Generator_ColumnVarNameInTable="columnchinhanh" msprop:Generator_ColumnPropNameInRow="chinhanh" msprop:Generator_ColumnPropNameInTable="chinhanhColumn" msprop:Generator_UserColumnName="chinhanh" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="getHoSoXetNghiem" msprop:Generator_TableClassName="getHoSoXetNghiemDataTable" msprop:Generator_TableVarName="tablegetHoSoXetNghiem" msprop:Generator_TablePropName="getHoSoXetNghiem" msprop:Generator_RowDeletingName="getHoSoXetNghiemRowDeleting" msprop:Generator_RowChangingName="getHoSoXetNghiemRowChanging" msprop:Generator_RowEvHandlerName="getHoSoXetNghiemRowChangeEventHandler" msprop:Generator_RowDeletedName="getHoSoXetNghiemRowDeleted" msprop:Generator_UserTableName="getHoSoXetNghiem" msprop:Generator_RowChangedName="getHoSoXetNghiemRowChanged" msprop:Generator_RowEvArgName="getHoSoXetNghiemRowChangeEvent" msprop:Generator_RowClassName="getHoSoXetNghiemRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ma" msprop:Generator_ColumnVarNameInTable="columnma" msprop:Generator_ColumnPropNameInRow="ma" msprop:Generator_ColumnPropNameInTable="maColumn" msprop:Generator_UserColumnName="ma">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="sophieu" msprop:Generator_ColumnVarNameInTable="columnsophieu" msprop:Generator_ColumnPropNameInRow="sophieu" msprop:Generator_ColumnPropNameInTable="sophieuColumn" msprop:Generator_UserColumnName="sophieu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="mabenhnhan" msprop:Generator_ColumnVarNameInTable="columnmabenhnhan" msprop:Generator_ColumnPropNameInRow="mabenhnhan" msprop:Generator_ColumnPropNameInTable="mabenhnhanColumn" msprop:Generator_UserColumnName="mabenhnhan" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tenbenhnhan" msprop:Generator_ColumnVarNameInTable="columntenbenhnhan" msprop:Generator_ColumnPropNameInRow="tenbenhnhan" msprop:Generator_ColumnPropNameInTable="tenbenhnhanColumn" msprop:Generator_UserColumnName="tenbenhnhan" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tuoi" msprop:Generator_ColumnVarNameInTable="columntuoi" msprop:Generator_ColumnPropNameInRow="tuoi" msprop:Generator_ColumnPropNameInTable="tuoiColumn" msprop:Generator_UserColumnName="tuoi" type="xs:int" minOccurs="0" />
              <xs:element name="gioitinh" msprop:Generator_ColumnVarNameInTable="columngioitinh" msprop:Generator_ColumnPropNameInRow="gioitinh" msprop:Generator_ColumnPropNameInTable="gioitinhColumn" msprop:Generator_UserColumnName="gioitinh" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="diachi" msprop:Generator_ColumnVarNameInTable="columndiachi" msprop:Generator_ColumnPropNameInRow="diachi" msprop:Generator_ColumnPropNameInTable="diachiColumn" msprop:Generator_UserColumnName="diachi" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="sobhyt" msprop:Generator_ColumnVarNameInTable="columnsobhyt" msprop:Generator_ColumnPropNameInRow="sobhyt" msprop:Generator_ColumnPropNameInTable="sobhytColumn" msprop:Generator_UserColumnName="sobhyt" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="hanbhyt" msprop:Generator_ColumnVarNameInTable="columnhanbhyt" msprop:Generator_ColumnPropNameInRow="hanbhyt" msprop:Generator_ColumnPropNameInTable="hanbhytColumn" msprop:Generator_UserColumnName="hanbhyt" type="xs:dateTime" minOccurs="0" />
              <xs:element name="chinhanh" msprop:Generator_ColumnVarNameInTable="columnchinhanh" msprop:Generator_ColumnPropNameInRow="chinhanh" msprop:Generator_ColumnPropNameInTable="chinhanhColumn" msprop:Generator_UserColumnName="chinhanh" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="getTCTonQuy" msprop:Generator_TableClassName="getTCTonQuyDataTable" msprop:Generator_TableVarName="tablegetTCTonQuy" msprop:Generator_RowChangedName="getTCTonQuyRowChanged" msprop:Generator_TablePropName="getTCTonQuy" msprop:Generator_RowDeletingName="getTCTonQuyRowDeleting" msprop:Generator_RowChangingName="getTCTonQuyRowChanging" msprop:Generator_RowEvHandlerName="getTCTonQuyRowChangeEventHandler" msprop:Generator_RowDeletedName="getTCTonQuyRowDeleted" msprop:Generator_RowClassName="getTCTonQuyRow" msprop:Generator_UserTableName="getTCTonQuy" msprop:Generator_RowEvArgName="getTCTonQuyRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="sochungtu" msprop:Generator_ColumnVarNameInTable="columnsochungtu" msprop:Generator_ColumnPropNameInRow="sochungtu" msprop:Generator_ColumnPropNameInTable="sochungtuColumn" msprop:Generator_UserColumnName="sochungtu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ngaychungtu" msprop:Generator_ColumnVarNameInTable="columnngaychungtu" msprop:Generator_ColumnPropNameInRow="ngaychungtu" msprop:Generator_ColumnPropNameInTable="ngaychungtuColumn" msprop:Generator_UserColumnName="ngaychungtu" type="xs:dateTime" minOccurs="0" />
              <xs:element name="taikhoan" msprop:Generator_ColumnVarNameInTable="columntaikhoan" msprop:Generator_ColumnPropNameInRow="taikhoan" msprop:Generator_ColumnPropNameInTable="taikhoanColumn" msprop:Generator_UserColumnName="taikhoan" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="chinhanh" msprop:Generator_ColumnVarNameInTable="columnchinhanh" msprop:Generator_ColumnPropNameInRow="chinhanh" msprop:Generator_ColumnPropNameInTable="chinhanhColumn" msprop:Generator_UserColumnName="chinhanh" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="phatsinhno" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnphatsinhno" msprop:Generator_ColumnPropNameInRow="phatsinhno" msprop:Generator_ColumnPropNameInTable="phatsinhnoColumn" msprop:Generator_UserColumnName="phatsinhno" type="xs:decimal" minOccurs="0" />
              <xs:element name="phatsinhco" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnphatsinhco" msprop:Generator_ColumnPropNameInRow="phatsinhco" msprop:Generator_ColumnPropNameInTable="phatsinhcoColumn" msprop:Generator_UserColumnName="phatsinhco" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="getTCCanDoiTaiKhoan" msprop:Generator_TableClassName="getTCCanDoiTaiKhoanDataTable" msprop:Generator_TableVarName="tablegetTCCanDoiTaiKhoan" msprop:Generator_TablePropName="getTCCanDoiTaiKhoan" msprop:Generator_RowDeletingName="getTCCanDoiTaiKhoanRowDeleting" msprop:Generator_RowChangingName="getTCCanDoiTaiKhoanRowChanging" msprop:Generator_RowEvHandlerName="getTCCanDoiTaiKhoanRowChangeEventHandler" msprop:Generator_RowDeletedName="getTCCanDoiTaiKhoanRowDeleted" msprop:Generator_UserTableName="getTCCanDoiTaiKhoan" msprop:Generator_RowChangedName="getTCCanDoiTaiKhoanRowChanged" msprop:Generator_RowEvArgName="getTCCanDoiTaiKhoanRowChangeEvent" msprop:Generator_RowClassName="getTCCanDoiTaiKhoanRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="taikhoan" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columntaikhoan" msprop:Generator_ColumnPropNameInRow="taikhoan" msprop:Generator_ColumnPropNameInTable="taikhoanColumn" msprop:Generator_UserColumnName="taikhoan" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tentaikhoan" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columntentaikhoan" msprop:Generator_ColumnPropNameInRow="tentaikhoan" msprop:Generator_ColumnPropNameInTable="tentaikhoanColumn" msprop:Generator_UserColumnName="tentaikhoan" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nodauky" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnnodauky" msprop:Generator_ColumnPropNameInRow="nodauky" msprop:Generator_ColumnPropNameInTable="nodaukyColumn" msprop:Generator_UserColumnName="nodauky" type="xs:int" minOccurs="0" />
              <xs:element name="codauky" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columncodauky" msprop:Generator_ColumnPropNameInRow="codauky" msprop:Generator_ColumnPropNameInTable="codaukyColumn" msprop:Generator_UserColumnName="codauky" type="xs:int" minOccurs="0" />
              <xs:element name="phatsinhno" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnphatsinhno" msprop:Generator_ColumnPropNameInRow="phatsinhno" msprop:Generator_ColumnPropNameInTable="phatsinhnoColumn" msprop:Generator_UserColumnName="phatsinhno" type="xs:decimal" minOccurs="0" />
              <xs:element name="phatsinhco" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnphatsinhco" msprop:Generator_ColumnPropNameInRow="phatsinhco" msprop:Generator_ColumnPropNameInTable="phatsinhcoColumn" msprop:Generator_UserColumnName="phatsinhco" type="xs:decimal" minOccurs="0" />
              <xs:element name="nocuoiky" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnnocuoiky" msprop:Generator_ColumnPropNameInRow="nocuoiky" msprop:Generator_ColumnPropNameInTable="nocuoikyColumn" msprop:Generator_UserColumnName="nocuoiky" type="xs:decimal" minOccurs="0" />
              <xs:element name="cocuoiky" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columncocuoiky" msprop:Generator_ColumnPropNameInRow="cocuoiky" msprop:Generator_ColumnPropNameInTable="cocuoikyColumn" msprop:Generator_UserColumnName="cocuoiky" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="getTCTonKho_TheKho_TheoLo_HanDung" msprop:Generator_TableClassName="getTCTonKho_TheKho_TheoLo_HanDungDataTable" msprop:Generator_TableVarName="tablegetTCTonKho_TheKho_TheoLo_HanDung" msprop:Generator_RowChangedName="getTCTonKho_TheKho_TheoLo_HanDungRowChanged" msprop:Generator_TablePropName="getTCTonKho_TheKho_TheoLo_HanDung" msprop:Generator_RowDeletingName="getTCTonKho_TheKho_TheoLo_HanDungRowDeleting" msprop:Generator_RowChangingName="getTCTonKho_TheKho_TheoLo_HanDungRowChanging" msprop:Generator_RowEvHandlerName="getTCTonKho_TheKho_TheoLo_HanDungRowChangeEventHandler" msprop:Generator_RowDeletedName="getTCTonKho_TheKho_TheoLo_HanDungRowDeleted" msprop:Generator_RowClassName="getTCTonKho_TheKho_TheoLo_HanDungRow" msprop:Generator_UserTableName="getTCTonKho_TheKho_TheoLo_HanDung" msprop:Generator_RowEvArgName="getTCTonKho_TheKho_TheoLo_HanDungRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ma" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnma" msprop:Generator_ColumnPropNameInRow="ma" msprop:Generator_ColumnPropNameInTable="maColumn" msprop:Generator_UserColumnName="ma" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ngaychungtu" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnngaychungtu" msprop:Generator_ColumnPropNameInRow="ngaychungtu" msprop:Generator_ColumnPropNameInTable="ngaychungtuColumn" msprop:Generator_UserColumnName="ngaychungtu" type="xs:dateTime" minOccurs="0" />
              <xs:element name="sochungtu" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnsochungtu" msprop:Generator_ColumnPropNameInRow="sochungtu" msprop:Generator_ColumnPropNameInTable="sochungtuColumn" msprop:Generator_UserColumnName="sochungtu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="sohoadon" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnsohoadon" msprop:Generator_ColumnPropNameInRow="sohoadon" msprop:Generator_ColumnPropNameInTable="sohoadonColumn" msprop:Generator_UserColumnName="sohoadon" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ngayhoadon" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnngayhoadon" msprop:Generator_ColumnPropNameInRow="ngayhoadon" msprop:Generator_ColumnPropNameInTable="ngayhoadonColumn" msprop:Generator_UserColumnName="ngayhoadon" type="xs:dateTime" minOccurs="0" />
              <xs:element name="mahang" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnmahang" msprop:Generator_ColumnPropNameInRow="mahang" msprop:Generator_ColumnPropNameInTable="mahangColumn" msprop:Generator_UserColumnName="mahang" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tenhang" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columntenhang" msprop:Generator_ColumnPropNameInRow="tenhang" msprop:Generator_ColumnPropNameInTable="tenhangColumn" msprop:Generator_UserColumnName="tenhang" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dvt" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columndvt" msprop:Generator_ColumnPropNameInRow="dvt" msprop:Generator_ColumnPropNameInTable="dvtColumn" msprop:Generator_UserColumnName="dvt" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="quicach" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnquicach" msprop:Generator_ColumnPropNameInRow="quicach" msprop:Generator_ColumnPropNameInTable="quicachColumn" msprop:Generator_UserColumnName="quicach" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="solo" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnsolo" msprop:Generator_ColumnPropNameInRow="solo" msprop:Generator_ColumnPropNameInTable="soloColumn" msprop:Generator_UserColumnName="solo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="hsd" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnhsd" msprop:Generator_ColumnPropNameInRow="hsd" msprop:Generator_ColumnPropNameInTable="hsdColumn" msprop:Generator_UserColumnName="hsd" type="xs:dateTime" minOccurs="0" />
              <xs:element name="soluongdauky" msprop:Generator_ColumnVarNameInTable="columnsoluongdauky" msprop:Generator_ColumnPropNameInRow="soluongdauky" msprop:Generator_ColumnPropNameInTable="soluongdaukyColumn" msprop:Generator_UserColumnName="soluongdauky" type="xs:decimal" minOccurs="0" />
              <xs:element name="soluongnhap" msprop:Generator_ColumnVarNameInTable="columnsoluongnhap" msprop:Generator_ColumnPropNameInRow="soluongnhap" msprop:Generator_ColumnPropNameInTable="soluongnhapColumn" msprop:Generator_UserColumnName="soluongnhap" type="xs:decimal" minOccurs="0" />
              <xs:element name="soluongxuat" msprop:Generator_ColumnVarNameInTable="columnsoluongxuat" msprop:Generator_ColumnPropNameInRow="soluongxuat" msprop:Generator_ColumnPropNameInTable="soluongxuatColumn" msprop:Generator_UserColumnName="soluongxuat" type="xs:decimal" minOccurs="0" />
              <xs:element name="soluongcuoiky" msprop:Generator_ColumnVarNameInTable="columnsoluongcuoiky" msprop:Generator_ColumnPropNameInRow="soluongcuoiky" msprop:Generator_ColumnPropNameInTable="soluongcuoikyColumn" msprop:Generator_UserColumnName="soluongcuoiky" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="getTonKho_Lo_HanDung_KhaDung" msprop:Generator_TableClassName="getTonKho_Lo_HanDung_KhaDungDataTable" msprop:Generator_TableVarName="tablegetTonKho_Lo_HanDung_KhaDung" msprop:Generator_TablePropName="getTonKho_Lo_HanDung_KhaDung" msprop:Generator_RowDeletingName="getTonKho_Lo_HanDung_KhaDungRowDeleting" msprop:Generator_RowChangingName="getTonKho_Lo_HanDung_KhaDungRowChanging" msprop:Generator_RowEvHandlerName="getTonKho_Lo_HanDung_KhaDungRowChangeEventHandler" msprop:Generator_RowDeletedName="getTonKho_Lo_HanDung_KhaDungRowDeleted" msprop:Generator_UserTableName="getTonKho_Lo_HanDung_KhaDung" msprop:Generator_RowChangedName="getTonKho_Lo_HanDung_KhaDungRowChanged" msprop:Generator_RowEvArgName="getTonKho_Lo_HanDung_KhaDungRowChangeEvent" msprop:Generator_RowClassName="getTonKho_Lo_HanDung_KhaDungRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="mahang" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnmahang" msprop:Generator_ColumnPropNameInRow="mahang" msprop:Generator_ColumnPropNameInTable="mahangColumn" msprop:Generator_UserColumnName="mahang" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tenhang" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columntenhang" msprop:Generator_ColumnPropNameInRow="tenhang" msprop:Generator_ColumnPropNameInTable="tenhangColumn" msprop:Generator_UserColumnName="tenhang" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dvt" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columndvt" msprop:Generator_ColumnPropNameInRow="dvt" msprop:Generator_ColumnPropNameInTable="dvtColumn" msprop:Generator_UserColumnName="dvt" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="quicach" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnquicach" msprop:Generator_ColumnPropNameInRow="quicach" msprop:Generator_ColumnPropNameInTable="quicachColumn" msprop:Generator_UserColumnName="quicach" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="solo" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnsolo" msprop:Generator_ColumnPropNameInRow="solo" msprop:Generator_ColumnPropNameInTable="soloColumn" msprop:Generator_UserColumnName="solo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="hsd" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnhsd" msprop:Generator_ColumnPropNameInRow="hsd" msprop:Generator_ColumnPropNameInTable="hsdColumn" msprop:Generator_UserColumnName="hsd" type="xs:dateTime" minOccurs="0" />
              <xs:element name="soluongdauky" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnsoluongdauky" msprop:Generator_ColumnPropNameInRow="soluongdauky" msprop:Generator_ColumnPropNameInTable="soluongdaukyColumn" msprop:Generator_UserColumnName="soluongdauky" type="xs:decimal" minOccurs="0" />
              <xs:element name="thanhtiendauky" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnthanhtiendauky" msprop:Generator_ColumnPropNameInRow="thanhtiendauky" msprop:Generator_ColumnPropNameInTable="thanhtiendaukyColumn" msprop:Generator_UserColumnName="thanhtiendauky" type="xs:int" minOccurs="0" />
              <xs:element name="soluongnhap" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnsoluongnhap" msprop:Generator_ColumnPropNameInRow="soluongnhap" msprop:Generator_ColumnPropNameInTable="soluongnhapColumn" msprop:Generator_UserColumnName="soluongnhap" type="xs:decimal" minOccurs="0" />
              <xs:element name="thanhtiennhap" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnthanhtiennhap" msprop:Generator_ColumnPropNameInRow="thanhtiennhap" msprop:Generator_ColumnPropNameInTable="thanhtiennhapColumn" msprop:Generator_UserColumnName="thanhtiennhap" type="xs:decimal" minOccurs="0" />
              <xs:element name="soluongxuat" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnsoluongxuat" msprop:Generator_ColumnPropNameInRow="soluongxuat" msprop:Generator_ColumnPropNameInTable="soluongxuatColumn" msprop:Generator_UserColumnName="soluongxuat" type="xs:decimal" minOccurs="0" />
              <xs:element name="thanhtienxuat" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnthanhtienxuat" msprop:Generator_ColumnPropNameInRow="thanhtienxuat" msprop:Generator_ColumnPropNameInTable="thanhtienxuatColumn" msprop:Generator_UserColumnName="thanhtienxuat" type="xs:decimal" minOccurs="0" />
              <xs:element name="soluongcuoiky" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnsoluongcuoiky" msprop:Generator_ColumnPropNameInRow="soluongcuoiky" msprop:Generator_ColumnPropNameInTable="soluongcuoikyColumn" msprop:Generator_UserColumnName="soluongcuoiky" type="xs:decimal" minOccurs="0" />
              <xs:element name="thanhtiencuoiky" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnthanhtiencuoiky" msprop:Generator_ColumnPropNameInRow="thanhtiencuoiky" msprop:Generator_ColumnPropNameInTable="thanhtiencuoikyColumn" msprop:Generator_UserColumnName="thanhtiencuoiky" type="xs:decimal" minOccurs="0" />
              <xs:element name="chuoiduynhat" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnchuoiduynhat" msprop:Generator_ColumnPropNameInRow="chuoiduynhat" msprop:Generator_ColumnPropNameInTable="chuoiduynhatColumn" msprop:Generator_UserColumnName="chuoiduynhat" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="getTonKho_Lo_HanDung_Thuc" msprop:Generator_TableClassName="getTonKho_Lo_HanDung_ThucDataTable" msprop:Generator_TableVarName="tablegetTonKho_Lo_HanDung_Thuc" msprop:Generator_RowChangedName="getTonKho_Lo_HanDung_ThucRowChanged" msprop:Generator_TablePropName="getTonKho_Lo_HanDung_Thuc" msprop:Generator_RowDeletingName="getTonKho_Lo_HanDung_ThucRowDeleting" msprop:Generator_RowChangingName="getTonKho_Lo_HanDung_ThucRowChanging" msprop:Generator_RowEvHandlerName="getTonKho_Lo_HanDung_ThucRowChangeEventHandler" msprop:Generator_RowDeletedName="getTonKho_Lo_HanDung_ThucRowDeleted" msprop:Generator_RowClassName="getTonKho_Lo_HanDung_ThucRow" msprop:Generator_UserTableName="getTonKho_Lo_HanDung_Thuc" msprop:Generator_RowEvArgName="getTonKho_Lo_HanDung_ThucRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="mahang" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnmahang" msprop:Generator_ColumnPropNameInRow="mahang" msprop:Generator_ColumnPropNameInTable="mahangColumn" msprop:Generator_UserColumnName="mahang" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tenhang" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columntenhang" msprop:Generator_ColumnPropNameInRow="tenhang" msprop:Generator_ColumnPropNameInTable="tenhangColumn" msprop:Generator_UserColumnName="tenhang" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dvt" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columndvt" msprop:Generator_ColumnPropNameInRow="dvt" msprop:Generator_ColumnPropNameInTable="dvtColumn" msprop:Generator_UserColumnName="dvt" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="quicach" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnquicach" msprop:Generator_ColumnPropNameInRow="quicach" msprop:Generator_ColumnPropNameInTable="quicachColumn" msprop:Generator_UserColumnName="quicach" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="solo" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnsolo" msprop:Generator_ColumnPropNameInRow="solo" msprop:Generator_ColumnPropNameInTable="soloColumn" msprop:Generator_UserColumnName="solo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="hsd" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnhsd" msprop:Generator_ColumnPropNameInRow="hsd" msprop:Generator_ColumnPropNameInTable="hsdColumn" msprop:Generator_UserColumnName="hsd" type="xs:dateTime" minOccurs="0" />
              <xs:element name="soluongdauky" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnsoluongdauky" msprop:Generator_ColumnPropNameInRow="soluongdauky" msprop:Generator_ColumnPropNameInTable="soluongdaukyColumn" msprop:Generator_UserColumnName="soluongdauky" type="xs:decimal" minOccurs="0" />
              <xs:element name="thanhtiendauky" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnthanhtiendauky" msprop:Generator_ColumnPropNameInRow="thanhtiendauky" msprop:Generator_ColumnPropNameInTable="thanhtiendaukyColumn" msprop:Generator_UserColumnName="thanhtiendauky" type="xs:int" minOccurs="0" />
              <xs:element name="soluongnhap" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnsoluongnhap" msprop:Generator_ColumnPropNameInRow="soluongnhap" msprop:Generator_ColumnPropNameInTable="soluongnhapColumn" msprop:Generator_UserColumnName="soluongnhap" type="xs:decimal" minOccurs="0" />
              <xs:element name="thanhtiennhap" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnthanhtiennhap" msprop:Generator_ColumnPropNameInRow="thanhtiennhap" msprop:Generator_ColumnPropNameInTable="thanhtiennhapColumn" msprop:Generator_UserColumnName="thanhtiennhap" type="xs:decimal" minOccurs="0" />
              <xs:element name="soluongxuat" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnsoluongxuat" msprop:Generator_ColumnPropNameInRow="soluongxuat" msprop:Generator_ColumnPropNameInTable="soluongxuatColumn" msprop:Generator_UserColumnName="soluongxuat" type="xs:decimal" minOccurs="0" />
              <xs:element name="thanhtienxuat" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnthanhtienxuat" msprop:Generator_ColumnPropNameInRow="thanhtienxuat" msprop:Generator_ColumnPropNameInTable="thanhtienxuatColumn" msprop:Generator_UserColumnName="thanhtienxuat" type="xs:decimal" minOccurs="0" />
              <xs:element name="soluongcuoiky" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnsoluongcuoiky" msprop:Generator_ColumnPropNameInRow="soluongcuoiky" msprop:Generator_ColumnPropNameInTable="soluongcuoikyColumn" msprop:Generator_UserColumnName="soluongcuoiky" type="xs:decimal" minOccurs="0" />
              <xs:element name="thanhtiencuoiky" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnthanhtiencuoiky" msprop:Generator_ColumnPropNameInRow="thanhtiencuoiky" msprop:Generator_ColumnPropNameInTable="thanhtiencuoikyColumn" msprop:Generator_UserColumnName="thanhtiencuoiky" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TCTonKho" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
  </xs:element>
</xs:schema>